Speed

  • Thread starter Thread starter James
  • Start date Start date
J

James

My database is slow. I have a backend on a new server
running Windows Server 2003 consisting of a few tables. I
then have a front end mde file with about 20 forms,
stored
in the users home directory. there are about 10 users.

The problem is that it takes ages to do anything, to load
a form or to find someone (there are about 80,000
records). This even happens when I copy both parts to a
local machine which is why I don't think its to do with
the network.

Any advice would be much appreciated.

James.
 
James said:
My database is slow. I have a backend on a new server
running Windows Server 2003 consisting of a few tables. I
then have a front end mde file with about 20 forms,
stored
in the users home directory. there are about 10 users.

The problem is that it takes ages to do anything, to load
a form or to find someone (there are about 80,000
records). This even happens when I copy both parts to a
local machine which is why I don't think its to do with
the network.
Click to expand...
Are the columns you are using indexed?
How much RAM do you have?

Finding one of 80,000 records (or doing something far more complex) on a
300 MHz machine seems almost instantaneous.
 
If it is slow when both parts are local, the problem would be in the
database structure (ie. table design) and/or query SQL.

Do all your tables have a primary key?

TC
 
Thanks for your reply

The coloumns that I search on are all indexed.

Each machine is 500mhz with 128mb ram.
 
Thanks for your reply

Yes they all have a primary key and the fields I search
are indexed.
 
James said:
Thanks for your reply

The coloumns that I search on are all indexed.

Each machine is 500mhz with 128mb ram.
Click to expand...
128 Mb is a bit tight on machines with XP. Other than increasing the RAM I
can only offer one suggestion that probably does not apply.
If the fields you are searching are part of a multipart key, the key is
indexed but the individual columns are not. (I can't even blame this one on
my dog.)
 
Back
Top