Options for sppeding up database execution

[DeanT]

I have a large database (49mb) that I want to speed up. Which would be the
better way: to delete unused queries, unused forms, unused reports or to
delete obsolete tables / obsolete records in large tables ?

I'm hesitant to do all because I'm not sure which components are obsolete or
unused.

Where do you suggest I start?

Thanks for your ideas.

 

[Rick Brandt]

I have a large database (49mb) that I want to speed up. Which would
be the better way: to delete unused queries, unused forms, unused
reports or to delete obsolete tables / obsolete records in large
tables ?

I'm hesitant to do all because I'm not sure which components are
obsolete or unused.

Where do you suggest I start?

Thanks for your ideas.

None of that will make your application any faster.

Speed in a database is all about reducing the amount of data moved around.
That means good indexing and retrieving the minimum amount of data for any
given task.

What you are proposing would make your file smaller, but that would do
almost nothing to make it any faster. Have you compacted lately? That
eliminates file fragmentation and performs a few other things to optimize
the application.

 

[Lars]

Maybe this can be of help:
http://www.granite.ab.ca/access/performancefaq.htm

 

[John W. Vinson]

I have a large database (49mb) that I want to speed up. Which would be the
better way: to delete unused queries, unused forms, unused reports or to
delete obsolete tables / obsolete records in large tables ?

I'm hesitant to do all because I'm not sure which components are obsolete or
unused.

Where do you suggest I start?

Thanks for your ideas.

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

Deleting objects won't affect the speed noticably. Indexing your tables
correctly and optimizing your queries will be much more effective.

 

[aaron.kempf]

have you considered moving to SQL Server?

The best part of SQL Server is that you can test indexes in 3
different ways in order to determine which indexes are the most
beneficial.

You are probably suffering from a lack of indexing.

SQL Server can provide you with the tools to properly index your
database.

-Aaron Kempf