Query very slow when record 30000

[oktavianus]

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]

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]

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

 

[oktavianus]

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

 

[oktavianus]

Mr. Chaster

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

okta

 

[Duane Hookom]

Indexes?

--
Duane Hookom
MS Access MVP

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

 

[oktavianus]

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]

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