Increase The Performance Of My Queries

[Corey]

I’ve been working with some very large databases, which are taking a long time to run

I am hoping I can get some advice on how I might be able to increase the performance of my queries?

Should I (examples)
1.Request to have more data archived or smaller amounts of data in the database
2.Request a new table added to the server with only customers I deal with.

Thank you for your time and help

Corey

 

[ShaneMan]

I’ve been working with some very large databases, which are taking a long time to run

I am hoping I can get some advice on how I might be able to increase the performance of my queries?

Should I (examples)
1.Request to have more data archived or smaller amounts of data in the database
2.Request a new table added to the server with only customers I deal with.

Thank you for your time and help

Corey

Hey Corey,

Just trying to lend a hand. Below is a link to Tony Toews website. I've sent you a link on dbase performance tips, so hopefully there will be something there that will help.

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

 

[Corey]

Thanks Shane

 

[ShaneMan]

Thanks Shane

Your welcome. I hope it helps your situation. If that website doesn't help, then let know. I'm at work so I don't have access to my links, but I know I have more, it's just that they are on my home computer and I can't remember where I found them.

Shane