2. ASPRunnerPro General questions
  3. Database Consuming Large Memory
This topic is locked

Database Consuming Large Memory

 		3/30/2005 4:27:47 PM
ASPRunnerPro General questions
P
 Preston author

I just now received a message from my web host of my database that they have suspended my website because they said it was using "unreasonable amounts" of memory on their server. This is an Access database with 120,000 records and about 100 fields--and no--I can't reduce the size any more.
They said I should be using SQL Server or something else that uses memory better.
Is there a patch or upgrade to the main product that will use memory better? Any suggestions? I need to do something fast to get the website back up.
Andy C 3/30/2005

I would try a repair and compact. This should bring it down significantly.
500232 3/30/2005

It isn't the size that is a problem--the database is about 125 meg. And it has been compressed everytime I load it. The problem is how much of it loads into cache memory.