Klaus Wrote: > when I had installed the 6.1.x on the fedore, i started checking the > queries that where done, and sometimes i think, there are some really > bad queries inside, that consume a lot of cpu to get out the data. but > I really can't remember that, but maybe I have to give a look to this, > and post the queries here. maybe is there a simple debug way to print > out all queries when using the webpage? > > but anyway, as SadGamerGeek mentioned, i also think the issue is when > you have big libraries, I also can try to load just maybe 1000 songs, > and check then the performance. Optimizing the database code is something being done for the 6.5 release, so I wouldn't spend much time poking around, as they're trying to phase out 6.3.x as quickly as possible. Don't expect any significant database work to be done in the 6.3 branch.
With 50,000 tracks I'd seriously give MySQL another shot. Try installing something like MySQL 4.1 or maybe 5.0. You should have enough memory to run it and SlimServer without a problem on XP. There's a lot more tweaking you can do with MySQL configuration settings than you can with SQLite. -- JJZolx Jim ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=25166 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
