Can anyone help me please. I have started writing an application in VB3
and Informix. I use Q+E to communicate with the database.
After I create a dynaset with approxiamtely 150 records in it,
it takes a very long time to read each record into the program.
I use: OpenDatabase to start, CreateDynaset to select a set of
record and MoveNext to access each record sequentially.

I find that when I ExecuteSQL to insert new records, the program also
becomes very slow. Is it anything wrong in this program and it there
any other way to speed up the execution?

Thank you

To work around this, you'd need to either use direct ODBC calls, or
use Q+E MultiLink, which is a higher-level wrapper around ODBC, and
does not use the Jet engine.

--

DBM Database Marketing Oy, Helsinki, FINLAND    " Q: What is the opposite
Tel: +358 0 605 900, Fax: +358 0 605 991         of information? "