JJZolx;647828 Wrote: > Here are the results of the first test with a 260,000 file library.
I've plotted those figures on a graph. Interesting - it shows that SQLite isn't linear - performance gets slightly worse as the library size increases, whereas MySQL is very close to linear. Obviously, this is a small sample size ;-) This does seem to match my experience - 40,000 songs, MySQL and SQLite scan times about the same. +-------------------------------------------------------------------+ |Filename: DB Engine.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=12224| +-------------------------------------------------------------------+ -- Philip Meyer ------------------------------------------------------------------------ Philip Meyer's Profile: http://forums.slimdevices.com/member.php?userid=95 View this thread: http://forums.slimdevices.com/showthread.php?t=89391 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss
