Pervasive & MS Access

[jennyj]

I am using Access to extract data from an Ingres database and loading the data to a Pervasive database table.

The extract from Ingres works fine but when I run a query to delete all records from the Pervasive table (prior to an update query) the data takes forever to delete ( 15secs per record and there are 5871 records to delete)

Does anyone know how to speed up this delete process?
Thanks

 

[Linda84]

It would be faster to just delete the table and recreate it, if you're deleting all the data anyway. If you want to do this via SQL, just issue a DROP TABLE and CREATE TABLE, assuming you know the table layout.

Other method #1: keep an "empty" version of the physical Btrieve file around, and when you want to delete all the records, just copy the empty version on top of the "real" version being referenced by the DDFs.

Other method #2: use the Btrieve API to programmatically re-create the file using the same name/location. You can even issue OPEN/STAT/CLOSE operations before the CREATE to get the file specifications.

The main drawback to all three of these methods is that no one can be accessing the file at the time you perform this. If that's not a problem, take your pick!
Linda
Pervasive Software Support