MySQL vs SQL Performance

Discussion in 'Bukkit Discussion' started by Retricide, May 18, 2012.

Thread Status:
Not open for further replies.
  1. Offline

    Retricide

    Which one offers better performance for a server running an array (pun intended) of plugins?

    I used to think MySQL is always a better alternative, but, after a bit of testing, I'm seeing increased server performance when running more plugins on SQL. I originally ran 7 plugins all on a MySQL server, but then switched 4 to an SQL database and saw improvements.

    What do you guys think? Is there a discernible difference, generally speaking?
     
  2. Offline

    Paswaru

    Do you mean SQLite?
     
  3. Offline

    rmb938

    MySQL is faster then SQLite(I am assuming this is what you mean) because SQLite is still a flat file. The performance also depends on the plugin. IF the plugin doesn't handle mysql well(ie close connections and what not) you will get performance issues. You will also get issues if you are using a remote database. The servers I work with are 90% mysql and all the mysql actions are timed and the maximum time needed to load/save something from/to the database is about 150 miliseconds.
     
Thread Status:
Not open for further replies.

Share This Page