database performace bad - very slow querys

  • Thread starter Thread starter Silas
  • Start date Start date
S

Silas

with over 450,000 records and about 24 fields I know it
will be slow but how could I speed it up without
upgrading to SQL Server. I already compacted and it
didn't do much
 
Hi,

With the amount of records you're talking about, there
wouldn't much performance gain in whatever you try.

Some suggestions:

-Eliminate some fields (probably not your preferred choice)
-Have only one user working with the database at once (If
this file is on a network, only have one person at a time
using the database will significantly speed performance)
-If you have forms, keep them very very simple
-Avoid excessively long dropdowns

These most likely won't do very much, but it's something
to try. But with the number of records you have, and
assuming they'll keep adding up, I strongly suggest you
migrate to a SQL Server database.

Regards,
Eric
 
What part is slow? Initial form load? Querying? Other?

Is the table indexed? Properly?

Is it on a network? Local HD?

Some details, please...
 
Back
Top