[Binx]

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.

[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.

[Binx]

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!