Zezicla Posted October 28, 2013 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 121 Reputation: 1 Joined: 12/01/12 Last Seen: May 9, 2015 Share Posted October 28, 2013 if im gone host more then 1000 players should i use MyISAM or InnoDBor even 1 player what should i use MyISAM or InnoDB ? Quote Link to comment Share on other sites More sharing options...
joelolopez Posted October 28, 2013 Group: Members Topic Count: 154 Topics Per Day: 0.03 Content Count: 493 Reputation: 46 Joined: 01/24/12 Last Seen: August 25, 2022 Share Posted October 28, 2013 trust me its MyISAM :3 Quote Link to comment Share on other sites More sharing options...
Asura Posted October 29, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted October 29, 2013 Hi Zezicla, If you truly have 1000 players, with a lot of data in MySQL; InnoDB is what you should be using. MyISAM is quicker when you have less SQL data, however, if your database exceeds GB; then you'll see that queries begin to lock up from time to time... causing lag. That is where InnoDB outperforms MyISAM, when your SQL database is extremely large; it does not lock up. Quote Link to comment Share on other sites More sharing options...
Zezicla Posted October 29, 2013 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 121 Reputation: 1 Joined: 12/01/12 Last Seen: May 9, 2015 Author Share Posted October 29, 2013 thanks ill use innoDB Quote Link to comment Share on other sites More sharing options...
Question
Zezicla
if im gone host more then 1000 players should i use MyISAM or InnoDB
or even 1 player what should i use MyISAM or InnoDB ?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.