Raised This Month: $32 Target: $400
 8% 

[MySQL] MySQL Version Advantages


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
SUSYABASHTI
Junior Member
Join Date: Nov 2014
Old 11-04-2020 , 10:50   [MySQL] MySQL Version Advantages
Reply With Quote #1

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
SUSYABASHTI is offline
r0ma
Senior Member
Join Date: Apr 2012
Location: Great Tomb of Nazarick
Old 11-04-2020 , 13:24   Re: [MySQL] MySQL Version Advantages
Reply With Quote #2

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.
__________________
Discord:FluffyDeveloper#4753
Github: https://github.com/francoromaniello
AMX-ES: https://amxmodx-es.com/r0ma'
r0ma is offline
Send a message via MSN to r0ma
SUSYABASHTI
Junior Member
Join Date: Nov 2014
Old 11-05-2020 , 11:45   Re: [MySQL] MySQL Version Advantages
Reply With Quote #3

Quote:
Originally Posted by r0ma View Post
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.
SUSYABASHTI is offline
r0ma
Senior Member
Join Date: Apr 2012
Location: Great Tomb of Nazarick
Old 11-05-2020 , 18:53   Re: [MySQL] MySQL Version Advantages
Reply With Quote #4

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
__________________
Discord:FluffyDeveloper#4753
Github: https://github.com/francoromaniello
AMX-ES: https://amxmodx-es.com/r0ma'
r0ma is offline
Send a message via MSN to r0ma
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:10.


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