Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete statement SLOW with Pervasive SQL 7 post SP6 (build 705)

Status
Not open for further replies.

Marcillis

IS-IT--Management
Aug 6, 2004
1
CA
I execute a simple program that does the following tests:
- Insert 1000 records into a table
- Read them from the table
- Delete them from the table
- Open and close 1000 times then same table
- Write 10,000K into an ASCII file
(access to the network without Pervasive)

I run that program at my office and the delete section takes 1.5 seconds.
I run that program at my client and the delete section takes 6.5 seconds.
All the others benches are faster at my client than at my office.

My office
---------
Server P3 1 ghz 1 gig Win 200
Station P4 1.8 ghz 512 megs XP
The network is 100MHz

My client
---------
Server P4 2.x ghz 2 gig Win 2003
Station P4 1.0 ghz 1 gig Win 2000
The network is 100MHz and 1GHz

I disabled the Anti-Virus on the server and station and I got the same result.

Does someone already have that kind of problems?
Should I modify something in the Pervasive Setup?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top