I am trying to duplicate a slice of data in a table, using a query like this one:
INSERT INTO SAMPLEDATA (EID, ...other 44 columns...)
SELECT 'eid_1' AS EID,...other 44 columns...
FROM SAMPLEDATA WHERE EID='eid_0'
Total number of rows in SAMPLEDATA= 193361
Total Number of columns= 45
Total number of selected/inserted rows= 27623
Taking times seems like there is a huge performance issue in the HXTT driver:
Sun's JDBC driver: 3,5sec
MS Access GUI: ~5sec
c++ driver: 5sec
That slow insert speed was resulted by recno verification for self insert. Changed. The latest package will be released after about 24 hours.