I ran a few SELECT tests on my PHP databasing system today. The results weren't too surprising, MySQL is way faster.
Here are the results for running a SELECT statement on table with 10,000 rows.
My System:
- 1st run. 3184.6 ms
- 2nd run. 2765.1 ms
- 3rd run and more. ~ 1090 ms
MySQL:
- All runs. ~ 30 ms
As you can see MySQL is much much much faster than my databasing system. This is probably on account that my script has to access many files and MySQL only has to access one large file.
The only way I can see that I can drastically improve speed of my database system is by rewriting it in C++.
Any other suggestions on how to improve performance?
Comment
See what others have to say on this topic, or add your own two cents.