Slow database

[Khushalay]

Hi Friends

I have two databases. The second database pulls values from the first database. This is working but takes a lot of time to pull values. How can I make it efficient and less time consuming.

I refreshed and compact it as well still no improvement.

Thanks in advance.

 

[JHB]

Like CJ_London says:
look to the bottom of this thread - there are a number of links to threads asking the same question!

 

[Khushalay]

Thanks alot