SQLite or MySQL
#1

I tend to get a bit of confusion when scripting because of what to use. Generally people use MySQL for roleplay gamemodes and what not, but which is faster? SQLite or MySQL, or are they equal speeds depending on what you use them for?
Reply
#2

previously used sqlite and switched to MySQL
MySQL is more effective than sqlite
Reply
#3

Another thing that you should do to guarantee speed is a proper database setting.
About which SQL language you should pick, I suggest MySQL since it is powerful and you are able to do much with it. Moreover, it might help you in the future of you are picking this as a job, also this will make making a UCP easier I believe..
MySQL is getting updated much - I didn't see much updates for SQLite.
If you are willing to pick SQLite check Slice's include "SQLitei".
Good luck!
I hope I helped any feedback would be appreciated!
Reply
#4

No matter what SQLite can always be faster than MySQL itself but mySQL itself has many online features which you cannot get or use in SQLite because it's not a server.
Reply
#5

Quote:
Originally Posted by Jake187
View Post
No matter what SQLite can always be faster than MySQL itself
Why? Is it because it's built into samp? For query execution is not, especially INSERT is really slow.

I'd agree it's more reliable, no extra needed but I'd still chose MySQL with threaded queries.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)