Re: Performance problems with Informix 7.x

Henrik Lie-Nielsen wrote: > > 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 Hi! I wouldn't know about drivers (I usually use Informix on Unix with ESQL/C linked into application tool I am using, Prolifics), but if you are more or less just loading ASCII files to database, it is much faster to use loader (or even 'load' statemet from dbaccess), even if you must first 'massage' your raw data (I often use perl for that purpose). Cheers! Dragi "Bonzi" Raos