JJZolx;648151 Wrote:
> No, I did not test with a 65,000 track library. The library had 260,000
> tracks. The results I posted above showed the elapsed time at different
> points in the scan.
>
> I see results similar to yours when the library is small.
>
Do you use any customized settings in your MySQL instance besides those
in the "High" Database Memory Config ?
If so, could you share them ?
Which MySQL version are you using ?
I'm using MySQL 5.0.21.
I just tried with a 250 000 track library (with 7.6.1 r33004) and
SQLite took about 4 hours for a full scan in my environment, MySQL is
in progress but about 6 hours after it has started it has still just
reached 100 000 out of 250 000 tracks, so it's clearly slower than
SQLite also in a large library in my setup.
Maybe it's just Linux vs Windows but it feels a bit strange that we get
such opposite results if it's just the operating system that differs.
Maybe it could be the CPU ?
My virtual machine only have access to one of the CPU cores and I'm
guessing you have a multi core CPU which probably is an advantage with
MySQL both since it runs in a separate process and also because it's
probably more optimized for usage with a multi core CPU than SQLite.
If our MySQL configuration is the same, maybe I'll try to run the 250
000 library directly on the laptop with a Core2Duo P8400 CPU to see if
I see the same thing in a non virtual environment with a dual core
CPU.
Besides Linux I have also have a Windows Vista installation on the
laptop so I could try how it looks in both Ubuntu and Vista on the same
hardware but I'm not sure that's worth anything as I think Windows Vista
is generally considered to be a lot slower than both XP and Windows 7
which it's probably more likely that people using Windows are using.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89391
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
