Hello There, Guest! Login or Register


MySQL
#8
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.

(02-26-2011, 06:43 PM)MidNight link Wrote: use y_ini its easy and the fastest way to write & save
man.. 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.
Reply


Messages In This Thread
MySQL - by LasTRace - 02-26-2011, 06:17 PM
Re: MySQL - by Lithirm - 02-26-2011, 06:33 PM
Re: MySQL - by MidNight - 02-26-2011, 06:43 PM
Re: MySQL - by thiaZ - 02-26-2011, 07:27 PM
Re: MySQL - by Kase - 02-27-2011, 09:33 AM
Re: MySQL - by firm - 02-27-2011, 12:09 PM
Re: MySQL - by Matthias - 02-27-2011, 01:41 PM
Re: MySQL - by Slice - 02-27-2011, 03:17 PM
Re: MySQL - by Russell - 09-26-2011, 12:04 AM