Query very slow when record 30000

oktavianus · Aug 17, 2003

hi there
i have created aplication wth msaccess 2000
query very slow when i use 3 tables at 1 query over LAN
my data 30000 each table

when i open the form , the form loadin takes time 1 minutes

any sugges abput this ??

thanks

Duane Hookom · Aug 17, 2003

You haven't provided any information regarding indexes and other conditions.
Is there code behind the form? How many combo or list boxes are contained in
your form?

You might want to review Tony's recommendations at
http://www.granite.ab.ca/access/performancefaq.htm

Chaster · Aug 17, 2003

Goto Options, View, General and see if you have Name Auto Correct enabled
if so disable and test your query.

oktavianus · Aug 17, 2003

i used unbound form
2 field unboud ( begdate and lastdate )
1 list box ( row source query that have 3 tables )
thanks

oktavianus · Aug 17, 2003

Mr. Chaster

I try again and solve a litte bit my problem and
thanks vr much

okta

Duane Hookom · Aug 17, 2003

Indexes?

--
Duane Hookom
MS Access MVP

oktavianus said:
i used unbound form
2 field unboud ( begdate and lastdate )
1 list box ( row source query that have 3 tables )
thanks

oktavianus · Aug 18, 2003

1. CarDetail
- car_no, owner, address
car_no as Prm Key

2. Work Order
- wo_no, car_no ,wo_date
wo_no as Prm Key Relation to CarDetail with car_no

3. Invoice
- no_inv,no_wo,inv_date
no_inv as Prm Key Relation to WO with wo_no

Thanks

Duane Hookom · Aug 18, 2003

You should have an index on the date field that you want to use to filter
your records. A general rule is to add an index for any field:
-involved in a join
-used to filter
-used to sort