Any reason for this?

[ChoonBoy]

I have two A03 MDB databases.

Both have identical tables and queries (actually one is a backup copy)

Database A execute queries very slow (can take 30 minutes or more)

Database B can execute the same query within 2 minutes.

What is the reason for this? All the queries became very slow after I added
a few new queries without disturbing the existing ones. After I discarded the
newly added, there is still no improvement at all.

What must I do to rectify this. I do not want to resort back to the faster
backup copy as I will have to replace all other users.

Thanks.

 

[John... Visio MVP]

I have two A03 MDB databases.

Both have identical tables and queries (actually one is a backup copy)

Database A execute queries very slow (can take 30 minutes or more)

Database B can execute the same query within 2 minutes.

What is the reason for this? All the queries became very slow after I
added
a few new queries without disturbing the existing ones. After I discarded
the
newly added, there is still no improvement at all.

What must I do to rectify this. I do not want to resort back to the faster
backup copy as I will have to replace all other users.

Thanks.

Have you tried compacting the database?

John... Visio MVP

 

[ChoonBoy]

Thanks for the response, yes I have tried compacting many times, I tried to
reimport everything to a new database and still no change in the speed.

I checked the sql line by line and they are identical too.