JamieMoore
05-07-02, 09:57
| 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?? |