snarlydwarf;566650 Wrote: > Just a point of reference from my library of 32k or something tracks: > reasonable size, IMHO, not insanely huge... but it trimmed clear and > rescan from 45mins to 32mins. > > So even with what I would think is a healthy sized library, SQLite is > still faster. Perhaps with huge libraries it is different.
That scans are much faster with SQLite has been acknowledged. Speculation is that it's the in-process nature of SQLite that makes an operation requiring 100s of thousands queries much faster. That alone probably wouldn't be reason for too many to switch, except those with slow machines where scans are taking hours. I run a daily clear & rescan and improving from 30 minutes to 15 minutes is fairly unimportant when it happens while I'm sleeping. A new & changed scan going from 6 minutes to 3 is also not much of an advantage. More important is server responsiveness doing the common tasks being asked of it, like browsing in the web and remote interfaces. But those things are much tougher to benchmark. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=80914 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
