gharris999;296544 Wrote: > Heh. What sort of hardware are you running SC on? A Cray? I _just_ > started thinking about trying to run some tests on a copy of my Cache > on a faster attached hard disk and see if that makes a difference. > Maybe the system disk has a bad sector on it or something.
In this case I was testing with a pretty speedy MacBookPro, so maybe the queries are executing fast enough that it's not falling flat like it is for you. I have a couple much slower machines that I can try this on, but it won't be until tomorrow. >From what you've investigated (and, kudos to you, you've investigated the *hell* out of it), It sounds like the underlying issue is an inefficient but not broken SQL query. Though I know SQL well, the actual SQL queries are mostly black box to me right now. I don't mind delving into fixing them if need be, however the dynamcially created SQL queries predate me by quite a bit... cheers, #!/ben -- bklaas "the Nokia770 skin guy" http://www.last.fm/user/bklaas/ ------------------------------------------------------------------------ bklaas's Profile: http://forums.slimdevices.com/member.php?userid=58 View this thread: http://forums.slimdevices.com/showthread.php?t=46850 _______________________________________________ jive mailing list [email protected] http://lists.slimdevices.com/cgi-bin/mailman/listinfo/jive
