Board index » delphi » URGENT! Still have SERIOUS speed problems!
Sun, 29 Apr 2001 03:00:00 GMT
URGENT! Still have SERIOUS speed problems!
We have an URGENT need to increase the performance of our database access.
We have a table with a couple thousand records of about 100 fields each,
with a composite index consisting of a single character string field
(Status) and a 7-digit string field (OrderNumber). We set a range on the
status character field, and loop through until EOF, changing the status of
each record (which obviously moves the record, so we don't do a Next).
On a Novell network, with a Win95 running Novell Intranetware client, it
takes ONE MINUTE to process ONE RECORD!!! Even on a win95 box with
Microsoft Client for Netware, it takes 6-7 seconds per record. We have made
every BDE and network modification that has been advised, and we have only
one user running the app at the time. We have totally run out of ideas for
speeding this thing up.
(Our win95 boxes are HP Vectras, at 233Mhz I believe, with 64M of RAM and
loads of disk space.) Can someone PLEASE help us?!?