MySQL v SQLite - Which one? - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL v SQLite - Which one? (/showthread.php?tid=67865)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL v SQLite - Which one? (/showthread.php?tid=67865)
MySQL v SQLite - Which one? - pyrodave - 04.03.2009
What should I use, MySQL or SQLite...
I currently use MySQL, but I have heard that SQLite it faster and doesn't have the memory leak problems that samp_mysql_free_result(); has for the MySQL plugins. But is it really? And are these memory leaks severe enough to cause major problems?
I have heard from some people that SQLite is faster to begin with, when the tables are small, but when the tables start getting large, it slows down dramatically. Is this true?
And if SQLite is faster and more suitable than MySQL, how could I convert everything from MySQL to SQLite? Such as the queries in the script, the tables I have, and the PHP scripts which read from the MySQL tables to show user data on a website.
Thanks very much
David
Re: MySQL v SQLite - Which one? - linxx - 04.03.2009
sql lite ftw mate it wins my miles
Re: MySQL v SQLite - Which one? - ICECOLDKILLAK8 - 04.03.2009
i prefer MYSQL
Re: MySQL v SQLite - Which one? - Cueball - 05.03.2009
Alex, wouldn't your reasoning also apply to YSI then? All the natives are, well, inbuilt (as they are natives), official, and supported.
Sure, YSI has practically everything anyone could ever dream of, but as it is unofficial, does this mean that it does not compare at all to the natives? I don't think so, as YSI is great, so I don't think your reasoning is perfect.
That's just my 2 cents, wasn't having a go or anything like that, so please don't take any offence to it
~Cueball~
Re: MySQL v SQLite - Which one? - MenaceX^ - 05.03.2009
Even after what you said Y_Less, I'd use MySQL instead of SQLite.