MySQL v SQLite - Which one?
#1

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
Reply


Messages In This Thread
MySQL v SQLite - Which one? - by pyrodave - 04.03.2009, 22:00
Re: MySQL v SQLite - Which one? - by linxx - 04.03.2009, 23:33
Re: MySQL v SQLite - Which one? - by ICECOLDKILLAK8 - 04.03.2009, 23:40
Re: MySQL v SQLite - Which one? - by Cueball - 05.03.2009, 02:59
Re: MySQL v SQLite - Which one? - by MenaceX^ - 05.03.2009, 10:12

Forum Jump:


Users browsing this thread: 1 Guest(s)