AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   [MySQL] MySQL Version Advantages (https://forums.alliedmods.net/showthread.php?t=328314)

SUSYABASHTI 11-04-2020 10:50

[MySQL] MySQL Version Advantages
 
If I use MySQL 8.0 on my website which is supposed to be extremely faster than MySQL 5.5 would the server make queries faster? or it depends on the MySQL module on the server?

Thanks for the helpers :)

r0ma 11-04-2020 13:24

Re: [MySQL] MySQL Version Advantages
 
dependent on the delay between the server and the mysql server.
if your mysql server are in the same network as your server will be more faster.

SUSYABASHTI 11-05-2020 11:45

Re: [MySQL] MySQL Version Advantages
 
Quote:

Originally Posted by r0ma (Post 2723715)
dependent on the delay between the server and the MySQL server.
if your MySQL server is in the same network as your server will be faster.

Yes, I know that already but that doesn't what I'm asking.
My question is if the MySQL module on the game server will gain the advantages of my MySQL version in the website.

And yes i intend to open the game server and the website on the same server.

r0ma 11-05-2020 18:53

Re: [MySQL] MySQL Version Advantages
 
If when you went from one version of mysql to the other for some reason you gained speed to process the queries for some optimization or something, obviously you will notice it on the server side having a faster response. You could measure how long it takes your mysql server to process the queries in one version and the other and compare the results, but I don't think it influences much.
https://www.tutorialspoint.com/how-t...sql-query-time


All times are GMT -4. The time now is 21:50.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.