http://www.dynaverse.net/forum/index.php/topic,163360955.msg1122633715.html#msg1122633715SG V
was using an SQL Database. The server
was crashing because this db method we
were using doesnt work right.
We plan to restart using a flatfile db Wed. for testing and launch the new server this Friday night. For those of you who do not know the difference, the Sql db we were using was starting to crash and add errors to the db. Flatfile DB doesnt do that. Sorry, but SQL isnt ready for prime time. We all thought we had most of it worked out, but clearly there are issues. I hope you all agree that it was worth it, in time SQL will get us where we want to be. But for now, flatfile db is where its at.
I believe most players, 90% of you will agree that you'd trade all the cool things SQL can offer for a stable server. So, lets take a look at the differences:
SQL vs Flatfile:
OoB: SQL - We are able to have true OoB on SQL. Flatfile its all house rules and CnC.
Webyards: SQL - SQL has all the ships you want all the time. Flatfile is luck of the draw, what you see in the shipyard is what u get.
Stability: Flatfile - we reached a point where flatfile hardly crashes. SQL... well you just saw how well that works.
Map DV Edits: SQL - Allows admin to easily edit the db on the fly changing planets/bases/ and DV's. Much harder to do on flatfile.
Time: Flatfile - Adjusting time in flatfile is easy and allows us to 'run the clock up or down' to get to what era or year we want.
Charcater pp edits, webmaps, and most of the other stuff are equal. All in all, I'd prefer to stick with flatfile. And thats what we will do.
[/list]
So what changes are in store for SG? Well, a maximum of 20 DV's for all hexes for one. We will do away with the 30 DV's we had, which were few. The rest of the RM designed map will be the same, tho.
Webyards, gone. The shipyards will run at 5-6 minute intervals, so finding a ship wont be that hard. The server will start in 2265 and run a day a game year ending on 2286-7 3 weeks from Fri to the following Sun so game year progression will be brisk.
DV editing: The map dv edits for PvP kills will not happen every 7 days. Instead, we will use the same points system allowing each side to use them in order to 'simulate' the capture of an enemy VC. PvP kill DV Points will be added up and the difference will be used by the winning side to see if they have enough to stretch their DV's far enough into enemy space to 'score' a VC. Exact details later. The map wont change, but the VC will be awarded should that side have enough to capture the planet given the defense of the current DV's there.
Adding/reomoving Bases/planets: We will see how hard it is on flatfile, but it is possible. So during testing, this feature will be decided on.
Battle Reporting: No auto web battle reports. Instead, Bonk will attempt a DE style web based report system where u login, type your race, name and ship, the enemy players race, name and ship u killed, the points it was worth and mb the stardate. Then it will sort it for me by points, race, side, players, etc. A neat handy tool to look up all a players stats and kills and totals and so forth.[/list]
So, we wont lose too much going to flatfile, but to say we will have a stable server that doesnt crash once an hour or two is enough.
Diz
Topic: SG V will be going flatfile, see link... Post edited (Read 4892 times)