10.10.2012, 19:11
Hello guys when i search through the forums i sometimes read that y_ini or INI is faster then MySQL i don't support this idea, but i just want to know if it is correct are there any speed tests ? Proving it ?
MySQL | vs | Flat File!
10.10.2012, 19:34
Fact is that the speed difference between the two (flat file storage and database file storage) is not important in most cases, but what you should use depends on what you want to do with the stored information.
For example, iterating through a list of users is really complicated when using multiple files. I mean, it is doable and can be scripted, but it will also be slow. Whereas, the same operation will most likely take like 10ms in the SQL server and the internal processor works with one, neatly indexed and laid out file, not multiple files.
However a badly tuned MySQL database/table is as bad as reading multiple huge flat-files in a loop! So watch out to optimize your creation!
For example, iterating through a list of users is really complicated when using multiple files. I mean, it is doable and can be scripted, but it will also be slow. Whereas, the same operation will most likely take like 10ms in the SQL server and the internal processor works with one, neatly indexed and laid out file, not multiple files.
However a badly tuned MySQL database/table is as bad as reading multiple huge flat-files in a loop! So watch out to optimize your creation!
11.10.2012, 06:38
Quote:
|
Originally Posted by AndreT
 Fact is that the speed difference between the two (flat file storage and database file storage) is not important in most cases, but what you should use depends on what you want to do with the stored information.
For example, iterating through a list of users is really complicated when using multiple files. I mean, it is doable and can be scripted, but it will also be slow. Whereas, the same operation will most likely take like 10ms in the SQL server and the internal processor works with one, neatly indexed and laid out file, not multiple files. However a badly tuned MySQL database/table is as bad as reading multiple huge flat-files in a loop! So watch out to optimize your creation! |
11.10.2012, 06:42
It all depends on amount of players in my opinion. Ini-files works well, but i am using MySQL because i believe that is faster.
However, it all depends on what use it is for.
However, it all depends on what use it is for.
11.10.2012, 07:14
Quote:
|
Originally Posted by Glint
So what is good from two from a small DM/TDM script ?
|
If you want leaderboards on a website, then MySQL is the way to go my friend, but it's a bit more advanced.
11.10.2012, 07:16
OK guys thanks for all of the responses.
Rep'ed
Rep'ed
« Next Oldest | Next Newest »
Users browsing this thread: 1 Guest(s)