Given that an Informix (7.1) Database is keyed and indexed
properly what data access method (Linked MS Access tables,
access jet, ODBC, RPC, others) will provide the quickest
return of data?
Currently I am converting an application from VB/MS Access
to VB/Informix. I am using ODBCDirect to retrieve data and
for the most part I am not using bound controls. An example
is retrieving a list of users (~2000 rows) to populate an
unbound combo box via a snapshot recordset. I am not pleased with the time it takes to perform this process (~10-15 seconds for each and 3 reside on this form). Or
is it a case where I need to use alternative pick lists?
In this case something other than a combo box?
Thanks for your assistance.