> > Pretty sure there would be cross platform issues with this, but there > may be ways round that. >
I'm sure it would not be without some difficulty, or I'm sure it'd have been implemented by now. It seems one of the more recurrent complaints is grumbling about the scanning process. I ESPECIALLY hate the "dump and rescan" option. :( > > One of the SlimDevices guys (i think it was Dean) stated in the past > that right now they haven't done a huge amount of optimisation on the > SQL queries for scanning. As they were moving to MySQL in 6.5 i think > they just wanted it to work reliably before they spend time on > optimising and tweaking. I would expect to see a speed improvement in > future versions as the Devs get more used to what MySQL can really do > for them :) > Agreed ... that's why I was putting in the 7.0 wish list. I've worked with SQLite before, and am aware of the limitations, and the sometimes screwy queries that you have to write for it. Glad to hear that query optimization is on the TODO list now that a more capable database engine is in place. -- jeffluckett ------------------------------------------------------------------------ jeffluckett's Profile: http://forums.slimdevices.com/member.php?userid=6179 View this thread: http://forums.slimdevices.com/showthread.php?t=26874 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
