On Tue, 22 Feb 2005 14:52:50 -0000, Mark Edwards <[EMAIL PROTECTED]> wrote: > Your output isn't very disimilar than mine, I use one more index, but it's > on a small table so unlikely to cause the discrepancies. > I suggest running ANALYSE and OPTIMISE on all tables in your DB. (I run them > every morning @ 5am) > Then check you are using query cache etc. > > Something is wrong with your DB, but I'm afraid I dunno what, at least we've > discounted Myth and indexes from your search...
Looking at chris's message I see his query is about 6 times faster with 6 times fewer recordings. Mysql says it's working though 2.1 million rows to process that query on my machine, you guys didn't report that figure for your queries, so I am curious about that. I am not a my myth computer now, but I will probably wind up hacking up the size of the recorded table to see if the query time is linear in that variable, or what. I have built and re-built this database like a dozen times so far, so unless ANALYSE and OPTIMISE perform miracles I am going to wonder if the particular query can be restructured, or if it can be just plain avoided, as chris mentioned a few days ago. Thanks Dan Manjarres
_______________________________________________ mythtv-dev mailing list mythtv-dev@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev