Queries running slow

[jnolfo]

I am having an issue running queries. They are just running very slow. I have split the stand alone tables into a separate file, and compacted/compiled the heck out of the database to be about 1% of the original size.

However, the queries still run slow. Most of the linked tables I base the queries are on a remote server. When I run the tables without a query...speed/performance is not an issue.

Could it be the pure number of queries I have set in the database. I only run one at a time thought.

Any thoughts would be greatly appreciated.

J

 

[pr2-eugin]

It depends how your queries are structured. Some common factors that affect performance..

* Are you using Like operators in your Queries?
* Are you using any Domain functions like DCount, DMax, DLookup etc. in Queries?
* Are you including the Indexed fields to run Queries?
* Are there any complicated JOINS?

Some other factors, that you might want to look at : Network connectivity, Persistent connection.

 

[jnolfo]

No like queries or domain functions (However, I am doing a Sum based on Groupings and Where's). Do have an indexed field that a Join is based on.