Need to Delete 1.6 million identical rows from a table 1

[djhawthorn]

How can I delete 1.6 million completely identical rows from a table?

I can run a select call and bring them up in the Control Manager, but if I change it to a DELETE syntax, the Control Centre falls over as its basically too much work and it can't handle it.

Is there another way to delete these records?

Alternatively, can we extract all the other records and put them in another (identical) table?

How can I go about this? Help appreciated

MCSE NT4/W2K

 

[mirtheil]

Try using PvQuery.exe from the COmponent ZOne (

http://www.pervasive.com/componentzone).

It's a command line utility that goes to the ODBC interface directly. You might also try ODBC Test from the Microsoft ODBC SDK.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[djhawthorn]

Thanks.

MCSE NT4/W2K

 

[grnelson]

Pervasive Btrieve is slow to delete. It updates and inserts much faster. If the number of records that you need to retrieve is much less than the records you want to delete you may look at creating a new file and query the records you want to save and send those to the new database. Another program you can use for the same purpose is BtSearch32 at

http://www.nssdd.com.

You can do a detailed query of the records you want to retrieve or exclude from the list and then export those to dbase. Then import those into an empty file.

Gil