I'm fairly new to using informix with ODBC (but have plenty of experience with other Dbs).

When I create a recordset using client-side cursors, it seems as though the informix driver is downloading the whole recordset to the client (I always thought it should created a set of pointers to the recordset locally). And when you've got each record as 17K and 77000 records it is going to be pretty slow (700MB I guess).

However if I use server side cursors it won't all me to make any updates, even if I change it around (cursor types etc) so it almost works if I call movefirst it seems to stop reflecting the updates I have made. It also seems to not commit the updates until the recordset is shut down (even though I am explicitly calling updatebatch). Any ideas??