Performance problems with Informix 7.x

Hi. I am currently working on a project to convert data from delimited ASCII files into an Informix 7.x database. We're writing an app in VB 6.0 and are using several ODBC drivers. (ADO as data access) We are experiencing severe performance problems and I am therefore wondering if any of you have any information that can aid us in improving the performance. Issues we have discovered: And ODBC trace reveals that after we execute a "SELECT * from tblX WHERE A = B", the driver does a "SELECT * FROM tblX" (a statement which is not in the application code). In addition, a cursor is created on the server for every insert statement, even if it's an iterative insert that creates records in the same table multiple times... I am interesting in finding out the following: Which is the no. 1 driver (as far as I can tell from the postings here it is probably Intersolv) Which is the best data access method (both insert and select) (ADO, DAO, Native driver ??? I am sadly a bit clueless here...) And finally, has anyone experienced similar performance problems under VB 6 with ADO ?? If you reply, please do so to henrikln@reaktor.no in addition to this group. Thanks for your time. Sincerely, Henrik Lie-Nielsen