So my conclusion: Flatfile > mysql with performance
Mysql > flatfile for maintaining.
Considering with the right setup Sql can achieve 1 billion reads per minute i cant see how you could possibly argue that Flatfile is better for performance. Perhaps in the short term with very few entries yes, but in the long term with hundreds of thousands of entries definitely not.
Sorry I haven't replied yet. Firstly, good luck with your project. If it fails, don't sweat it. You'll learn a lot from it. Secondly, I take a stand with Jack. I don't use Sql just because it's my preference. I use it because it's built to manage large stale database projects and servers. It took me a while to understand why at first too, but until you do, just take our word for it. Also, remember that database test I did? It's not right. I tested each database system on initialization and on the first few sql commands (each command being executed over 30 seconds apart). Sql out-performs ini! Good luck (again).
^ It probably does perform *INI* but thats not the only flatfile database is ist now?
Small update: Was chilling most of yesterday and taking abit of a break, so I only got Items, Inventory and equipment done, Still got saving+loading todo, and one small bug in equipment(showing to others) to fix.
Considering with the right setup Sql can achieve 1 billion reads per minute i cant see how you could possibly argue that Flatfile is better for performance. Perhaps in the short term with very few entries yes, but in the long term with hundreds of thousands of entries definitely not.
like ive said, im going from past expierence, not getting into technical setups or properly configured ****, flat file did well for me, and in my expierence i find it better than mysql for performance. im not saying its a global fact lol.
So, I got bored coding inside my source so I decided to explore anticheats, I worked it out I spent over 25 hours attempting to start it off, failed(wasnt my fault it turns outs) so superman came to my rescue(Ultimation) so now, its well under way, Will continue work on source once anticheat is complete, however I did completely finish equipment and inventory saving!, Oh and I fixed that bug.
I would like to repeat, This server will not be public unless I find some real thrive of players wanting another PVP server, specially not while AcidCO is around anyway(Why would I run a PVP server, while the greatest of all time is still around? + I play it ;D)
Ran into a few peoblems, I stopped work for some time.
Starting work again.
Anticheat ETA: few days.
AcidCO is closed, I can consider opening the server to public should there be a demand, would you guys like to see this server open for everyone or no?
oh man. i learned so much from creating this source 5 years ago haha it was almost like a big stepping stone, despite half of the comments on the thread i think it was fundamental into becoming the programmer i once was
oh how time flies. (also -- how and why was this thread bumped? lol)
help me source 5517 plz :( 10/20/2012 - CO2 Private Server - 11 Replies http://img5.pimp-my-profile.com/i57/5/9/30/f_a9b54 b44b2ca.jpg
hello need help with that mistake a person who knows how
repair it if you could tell me how to fix it
I will appreciate endlessly only error is that I
Please ask him to give me help with that
58 errors and error screen time GameState.cs 842 help me plz :(
Auto CP in Albetros Source 5517 05/07/2012 - CO2 Private Server - 15 Replies Okay so im alittle confused...I tryed changing so many settings and yet have to find the right one i cant seem to get the monsters to give cps. I went into monster.cs and i thought i found it but what i did there didnt work ether if anyone can help me id appreciate it. Im not asking to give me the answer im asking to help me point me in the right direction.
SOURCE 5517 SHUTDOWN 12/21/2011 - CO2 Private Server - 5 Replies ----Exception message----
Source array was not long enough. Check srcIndex and length, and the array's lower bounds.
----End of exception message----
----Stack trace----
at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)
at System.Collections.Generic.Queue`1.SetCapacity(Int 32 capacity)
at System.Collections.Generic.Queue`1.Enqueue(T item)
at...
Source 5517+ Problem critics 09/21/2011 - CO2 Private Server - 2 Replies Good for all
The server I'm using is 5517 + eragon
and my problem is that when going from 10 to 15 online
the server shuts down
info +
enter here kanasai not Lucky7
that's my only problem for now
Help xD
http://s3.subirimagenes.com:81/fondosycapturas/pr evio/thump_6936303nueva-imagen-de-mapa.jpg
a question about trinity 5517 source 09/18/2011 - CO2 Private Server - 3 Replies Sometimes ,i can't saw another player when the player didn't jump didn't walk ,only sit in a coord or player away!!!
but the another player can saw me ....
where the error occurred ???
any one fix there ?
source Link:source and database.rar
![[Development] 5517 PVP Source](https://www.elitepvpers.com/forum/iconimages/co2-private-server/development-5517-pvp-source_ltr.gif){kind=small}
It probably does perform *INI* but thats not the only flatfile database is ist now? 
