Any reason for this?

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

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.
 
ChoonBoy said:
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.
Click to expand...


Have you tried compacting the database?

John... Visio MVP
 
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.
 
Back
Top