What does EXPLAIN show for the query on both systems? (I am wondering if you may have an index on your development system that you do not have on your production server.)
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Graham Cossey" <[EMAIL PROTECTED]> wrote on 11/11/2004 11:19:08 AM: > Hi > > Can someone offer any advice on a strange problem I have at present... > > If I run a certain query (see below) on my local development PC using > mysqlcc it returns in 3.7s. > > If I run the exact same query on my live webserver (again using mysqlcc) I > have yet to get a result !! > > Both databases have the same table definitions (live db originally created > from mysqldump of dev PC) and have exactly the same [number of] records in > each table. Both machines are running MySQL 3.23.58. Dev PC if Fedora Core2, > live is RedHat 9. > > Other than this one query all else appears normal, any suggestions? > Let me know if you need more info and I'll attempt to supply it... > > Many thanks > > Graham > > Query: SELECT code, sum(qty) as total > FROM table1 as d, db2.table2 as r, table3 as p > WHERE year=2004 AND month=10 AND r.col1=p.col1 and d.code=p.code and > from_period <= 200410 and to_period > 200410 and d.col3!='6' > GROUP BY code > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
