Re: Database Information Storage
From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 12/30/04
- Next message: geeksdoitbetter: "RE: Change target for a query?"
- Previous message: geeksdoitbetter: "searching memo fields"
- In reply to: ethan: "Database Information Storage"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 11:42:36 -0500
Do you have indexes on the fields that you are using in searches and sorts?
Other than that there is not a lot you can do to speed up the data. Also, you
must realize that indexes represent a tradeoff - it takes longer to add, delete
and modify a record if indexes are involved. The indexes have to be updated at
the same time.
Other than that your choice is to archive some of the rows of data into a
separate table if it is not really needed.
One other thing that may help, is to compact your database. Doing this is (as I
recall) supposed to force the database to reexamine the query plan for all
queries and update them as appropriate.
Opening a query in design view and changing it, saving the change, and then
undoing the change and saving again, will also force the database engine to
reexamine the query plan and make optimizations to the query plan.
ethan wrote:
>
> I produced a database that is being fed with new information every week. So
> rar it has more than 1 mln lines (records). and the queries are slwing down
> as the table gets biger and biger. Is there any way to fix it...
- Next message: geeksdoitbetter: "RE: Change target for a query?"
- Previous message: geeksdoitbetter: "searching memo fields"
- In reply to: ethan: "Database Information Storage"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
