tmysqloo vs MySQL database - Developers

Hello guys, i'm currently in the progress of reinstalling my server, I was wondering what would be more of a performance boost, keeping the addon ItemStore - Inventory on text mode (which saves to the server's datafolder) or- transfer it to MySQL? This is a very brief question, hoping i'll get some informative answers. Thank you!

Your title suggests that storing data in text files = tmysqloo. [editline]4th November 2015[/editline] About your question tho - use mysql. SQL: - one file, unless you make more for organization purposes - well organized, in most cases no need to convert data that you read from it (unless you want to store a table as a string) - fairly low file size - well organized Text files: - 1 file per player, which can grow into thousands - converting it's contents into lua-readable code is a must - badly organized, you can't sort whole database (if a pile of files can be called that) without opening all of them, putting into huge table and then sorting through it, while in sql you just run an appropriate query

[QUOTE=Netheous;49047062]Your title suggests that storing data in text files = tmysqloo. [editline]4th November 2015[/editline] About your question tho - use mysql. SQL: - one file, unless you make more for organization purposes - well organized, in most cases no need to convert data that you read from it (unless you want to store a table as a string) - fairly low file size - well organized Text files: - 1 file per player, which can grow into thousands - converting it's contents into lua-readable code is a must - badly organized, you can't sort whole database (if a pile of files can be called that) without opening all of them, putting into huge table and then sorting through it, while in sql you just run an appropriate query[/QUOTE] Alright, I appreciate your response very much. I have realized my data folder stacked with tens of thousands of files for every single user on my server, but my buddy insisted that keeping it on "text" mode will reduce lag.

[QUOTE=Elpisaur;49047106]Alright, I appreciate your response very much. I have realized my data folder stacked with tens of thousands of files for every single user on my server, but my buddy insisted that keeping it on "text" mode will reduce lag.[/QUOTE] If text files were more efficient than one, big database then we would be still using them?

[QUOTE=Elpisaur;49047106]Alright, I appreciate your response very much. I have realized my data folder stacked with tens of thousands of files for every single user on my server, but my buddy insisted that keeping it on "text" mode will reduce lag.[/QUOTE] Hi, I'm the author of ItemStore. Your buddy is half-correct, MySQLoo is incredibly slow when dealing with many queries for some reason. When using tmysql4, this problem is alleviated and you won't see any lag spikes. I'd recommend that you use the tmysql data provider over the mysqloo one (and if you're using the new version, then you have no choice, it always uses tmysql) It certainly doesn't help that my mysql code is an absolute clusterfuck that needs refactoring but whatever.