SA-MP Forums Archive
MySQL versions - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL versions (/showthread.php?tid=504540)


MySQL versions - Binx - 04.04.2014

I know that there are different versions of MySQL. But is there any difference using R6? I know it of by heart, however, I don't really understand threaded version. Is it really that much slower to "not" use it?

Regards.

Re: MySQL versions - Vince - 04.04.2014

I wouldn't put my finger on it, initially. However, as your playerbase grows so will your database. Searching through larger tables takes more time. Meanwhile, the server also needs to keep track of players and events. It can't do that while executing a non-threaded query. Regular selects are fairly doable, but once you start to join, group and order the results the execution time significantly increases. Consider this real life example:

PHP код:
SELECT country_code, count(*) AS amount 
FROM core_ip_table 
GROUP BY country_code 
ORDER BY amount DESC 
A table with 80k rows. Grouping and ordering takes approximately 60 milliseconds.

Sticking to an older version because you know it isn't really an excuse either. That would be like sticking with DOS while you could use Windows 8. Eventually you'll have to upgrade. Better to do it sooner than later.

Re: MySQL versions - Binx - 04.04.2014

Quote:
Originally Posted by Vince
Посмотреть сообщение
I wouldn't put my finger on it, initially. However, as your playerbase grows so will your database. Searching through larger tables takes more time. Meanwhile, the server also needs to keep track of players and events. It can't do that while executing a non-threaded query. Regular selects are fairly doable, but once you start to join, group and order the results the execution time significantly increases. Consider this real life example:

PHP код:
SELECT country_code, count(*) AS amount 
FROM core_ip_table 
GROUP BY country_code 
ORDER BY amount DESC 
A table with 80k rows. Grouping and ordering takes approximately 60 milliseconds.

Sticking to an older version because you know it isn't really an excuse either. That would be like sticking with DOS while you could use Windows 8. Eventually you'll have to upgrade. Better to do it sooner than later.
I understand, but I really can't get the hang of threaded queries. I'll most likely update sometime in the future(if it was taking it's time), thanks anyway Vince!