02-27-2011, 03:17 PM
Matthias, you should check out this topic I made about benchmarking: http://forum.sa-mp.com/showthread.php?t=218491
Also, MySQL can be even faster than your results as you didn't thread your queries. If you thread the queries then it should take only a few nanoseconds for PAWN to run a query.
To sum this up (very briefly):
MySQL:
y_ini:
Also, MySQL can be even faster than your results as you didn't thread your queries. If you thread the queries then it should take only a few nanoseconds for PAWN to run a query.
(02-26-2011, 06:43 PM)MidNight link Wrote: use y_ini its easy and the fastest way to write & saveman.. you're just stupid.
Quote:Y_ini would be about as fast as dini, which isn't fast at all.dini is way slower than y_ini. Loading 400000 values took y_ini 1564 ms, but just above a minute for dini.
Quote:f you save an account with several fields, maybe 10, the server would lag for like 0,2 seconds.With y_ini, my guess is it wouldn't take more than 1-3 ms.
To sum this up (very briefly):
MySQL:
- Is significantly faster.
- Can be read from and written to simultaneously by multiple applications.
- Can perform things such as sorting, filtering, grouping to your data.
- Can be located externally.
y_ini:
- Is simple and fast enough for small servers.
- Allows for easy modifications to the data by simply editing text files.