PDA

View Full Version : SQLite faster then MySQL!?



treble
2006-02-01, 18:49
Hi,

I installed MySQL awhile ago, hoping that my slimserver would run a bit quicker. But it created actually more problems, like whenever a new song was requested during Random Mix there was a 10 second pause or so (see my post: http://forums.slimdevices.com/showthread.php?t=20494 ).

Then I realized that even starting a Random Mix could take over 20 seconds. So I tried going back to SQLite, and now... all seems a lot faster. A new Random Mix starts after about 5-6 seconds...

My PC is has an AMD Athlon XP 1150MHz CPU with 512+256=768M of memory. SlimServer Version: 6.2.2 - 5815 - Windows 2000 - EN - cp1252. Other then slimserver not much else is using CPU or Memory.

Any ideas why SQLite is fater then MySQL?

It seems my CPU usage is similar to that posted for another Win2000 machine: http://forums.slimdevices.com/showthread.php?t=20641