First of a series of questions. 1. Table vs. Questions

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Hello All,

I'm beginning to build a massive database with more than 10 tables.
Currently I have 1 database with 4 tables and 1 query linking certain info
from the tables. The query is rather slow when the number of records go
over 1000. Is there a way to speed this up when it opens? Which one would
you recommend for interactions between tables? Thank you.
 
hi Paul,
I'm beginning to build a massive database with more than 10 tables.
Click to expand...
Massive is something completly different :)
Currently I have 1 database with 4 tables and 1 query linking certain info
from the tables. The query is rather slow when the number of records go
over 1000. Is there a way to speed this up when it opens? Which one would
you recommend for interactions between tables? Thank you.
Click to expand...
First of all, have all your tables primary keys?
Then add for the fields used in your query indices in the tables.

btw, what exactly is "rather slow"? Are you running the .mdb on a local
drive (what kind of drive)?


mfG
--> stefan <--
 
Hello All,

I'm beginning to build a massive database with more than 10 tables.

Currently I have 1 database with 4 tables and 1 query linking certain info
from the tables. The query is rather slow when the number of records go
over 1000. Is there a way to speed this up when it opens? Which one would
you recommend for interactions between tables? Thank you.
Click to expand...

What are you doing with the query? It's rarely necessary to create One Great
Master Query linking everything in your entire database together; typically
you'll have Forms bound to one- or two-table queries for data entry, and
Reports bound to queries joining several tables, but typically retrieving only
those few records which need to be reported. Having a query joining all ten
tables and displaying all records in those tables would be very unusual
indeed!

You may want to look at Tony Toews' Performance FAQ:

http://www.granite.ab.ca/access/performancefaq.htm


John W. Vinson [MVP]
 
Back
Top