Wortz, Charles
CWortz at tea.state.tx.us
Wed Apr 16 11:44:29 CDT 2003
Do both dbs have the same tables with the same indexes on them? If the second db is missing an index that the query uses, then it may be forced to do a table scan which is much slower for large tables. If that is not the problem, then you will have to give us more information about these two dbs. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Kaup, Chester A [mailto:kaupca at ChevronTexaco.com] Sent: Wednesday 2003 Apr 16 11:22 To: accessd at databaseadvisors.com Subject: [AccessD] Query Run time in different databases I have a query that takes about 10 seconds to run in one database. I copied the query into another database using the menu bar. The query tries to run for hours in the database it was copied into. The original database is larger if that matters. A compact and repair seemed to have no effect. Any thoughts as to what is happening? No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030416/a551acec/attachment-0001.html>