timeout problem with "large" table

[Florian Bogeschdorfer]

V4MD1.11 Client/Server

 

Hi all!

 

I have a serious problem with my database. If I add a record to a table it
takes up to 60 seconds! This leads to a TCP/IP timeout error in the end
(10060). This is with 11000 records and about 80 fields. The time lag
increases depending on the number of records in the table. I have two
databases from two different customers with the same problem. I can change
records fast as usual but adding records has actually become impossible.

If I delete 10000 records, then adding records again is fast as usual.

 

I have defragmented, compacted and reindexed the database. I have also
checked the integrity with VStudio - "All right".

 

I can not switch to 2.0 in the next days and my customers are seriously
angry now.

 

Any ideas?

 

TIA,

 

Florian Bogeschdorfer