search

RedEM-RP / redem_roleplay

RedEM Roleplay Framework
https://discord.gg/nbmTmZR
Other
61 stars 51 forks source link

InnoDB for MyISAM conversion #46

Closed ALTITUDE-DEV-FR closed 1 year ago

ALTITUDE-DEV-FR commented 1 year ago

MyISAM is too optimised as well for InnoDB format.

Exemple :

Table outfit with 1 entry in InnoDB = 16 ko in MyISAM is 4.4ko only , imagine for all tables with lot of datas, you increase the performances SQL ;)

A big database for a big server is reduce the weight to X15 !

(is recommanded for php website example (WordPress or others CMS popular)

Dear Shepard

imthatguyhere commented 1 year ago

I think this needs to have all of the downsides discussed. You lose row level locking, storage engine foreign keys, and much more. There are also many circumstances where MyISAM is slower.

At the rate we are talking here, having a relational database makes more sense over the size of a table, especially when there are better suited database solutions that will outpace MyISAM if you didn't want to use any of the extended feature set.

kanersps commented 1 year ago

MyISAM Is also old and deprecated lol, additionally, it doesn’t have any of the same data integrity guarantees that InnoDB has.Obviously this is not an improvement, please research the reason why InnoDB was chosen in favor.On 31 Jan 2023, at 04:15, imthatguyhere @.***> wrote: I think this needs to have all of the downsides discussed. You lose row level locking, storage engine foreign keys, and much more. There are also many circumstances where MyISAM is slower. At the rate we are talking here, having a relational database makes more sense over the size of a table, especially when there are better suited database solutions that will outpace MyISAM if you didn't want to use any of the extended feature set.

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: @.***>

ALTITUDE-DEV-FR commented 1 year ago

In that case i cancel this push =) Because on the contrary MylSam is not deprecated, 90% of the web uses it for example... it is not necessarily the same condition on a game in lua.

ALTITUDE-DEV-FR commented 1 year ago

My Bad i have see this nice news (french) : https://kinsta.com/fr/base-de-connaissances/convertir-myisam-vers-innodb/#:~:text=Beaucoup%20d'anciens%20sites%20utilisent,au%20niveau%20de%20la%20table.