Re: Querying across Multiple Databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Brad

Whooo! 50 Gbytes is quite a database. Any chance images are being stored?

Given that size, I'd be looking into SQL Server or ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Brad Autry" <BradAutry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D47AF3BD-20E4-41EE-B94D-AC81538FCF22@xxxxxxxxxxxxxxxx


"Jeff Boyce" wrote:

Brad

How is it that your database(s) have gotten so large? Have you backed up
your files recently, then run Compact & Repair?

Define "massive" -- it isn't at all uncommon to have data in the 50-100
Mbyte range.

Regards

Jeff Boyce
Microsoft Office/Access MVP


The database, in total, is roughly 50 gigs. I was a bit taken aback by
its
size, needless to say. It is a historical database dating back 5 years or
so
of applicant data for a large company. I need to pull data for specific
work
locations over given periods of time. I'm investigating what options I
have,
in regards to moving the data to a SQL or Oracle server here, as running
even
one of the 40+ queries I need to run to yield one selection of data is
taking
upwards of 10 minutes to run. Taking roughly 6 hours to get the
equivalent
of one query's worth of data is not something I'm looking forward to.

I am also trying to figure out how to use variables for the selection
criteria to at least somewhat streamline this process.

Thanks to everyone for your feedback. Wish me luck!


.

Relevant Pages