Posts: 404
Threads: 104
Joined: Sep 2008
Reputation:
0
So let's say i have a need to search all of the accounts on my server for a specific value.
Would it be faster to do it by opening files (if it was a .ini system) or by a query (if it was a MySQL system)?
Im asking this because i will have that need in the future, and if my need is done faster by MySQL i would switch to it.
I hope you understand what i meant...
Posts: 673
Threads: 45
Joined: May 2010
Reputation:
0
switch to mysql it is very nice, very fase and you can make some functions!
and i can help you by making a mysql system
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Executing a single (threaded) query in a database will definitely be faster than opening every ini file and checking for a value. If you have a popular server, the registered accounts can run into the 10,000. Opening them all would lag your server for quite some time.
Posts: 1,418
Threads: 63
Joined: Dec 2010
Reputation:
0
I use .ini files because I can't understand MySQL, but MySQL is faster
Posts: 673
Threads: 45
Joined: May 2010
Reputation:
0
for all im making a tutorial for a mysql reg system with enum tomorrow
Posts: 138
Threads: 25
Joined: Aug 2011
Reputation:
0
100 - 200ms, i'm ASSUMING. Remember, this is an assumption, and is probably nowhere near correct. You could easily check this by creating a simple script and executing a query searching for one value 10,000 times, and then using gettickcount(); to check for the time.
