Slow Database

  • Thread starter Thread starter Trisha
  • Start date Start date
T

Trisha

I have a department that uses a database to access
information for a third party software. This database, as
of two weeks ago, was of acceptable speed. However, now
they are complaining that it is very slow. I removed a
table that they are not using and compacted the database.
They only have one table in the database and that's it.
This table is a large table (65,000 records and about 50
columns). The size is 131 mb. Last week I removed some
duplicate records, but after everything I have compacted.
It is also on our network and I don't think that has
slowed down at all recently. From what I did, it doesn't
make sense to me that it would slow down "substantially"
as they are reporting.

Anyone have any ideas why this would cause a slow down and
what I can do besides a compact/repair to help the
situation?

Thanks for your help,
Trisha
 
Hi Trisha

My question is: how is this application configured?

Do you have it as a BackEnd/FrontEnd?

Since you mention 'Department' .. I presume that you are sharing this file on a
file server. Has anything changed on the file server?

Keep us posted.

Maurice
 
This database is not split into backend/frontend. I
assume they didn't do that since the one table is the only
thing in it. Nothing has changed on the file server and
there are three people who access this database. Not
necessarily all at once though. It is also in 97.


Trisha
 
I was able to fix the speed. I imported the one table to
a new database and then renamed the new database to the
old name so the software application would pick up the new
one. It fixed the speed issue. I still don't understand
it, but at least it's fixed. I would still like to know
why it would slow down that much if anyone has any ideas.

Thanks,
Trisha
 
Back
Top