Am using Msofts ADO (
VB 6) objects to connect to DB2 7 server.
Using recordset objects my add record process is taking much longer than expected. Old DAO from Access97 performs much quicker.
Table only has about 300K records in it and 1 index (the PK).
Hints? Suggestions? DB2 client tweaks?