VB and Online 5.10
Posted in 1999
Steven Weiss — — source: Informix-list mailing list archive (1991-1998)
Hi I wonder if anyone out there can help me. I'm connecting to an Informix Online 5.10 database (service : sqlexec, protocol: olsoctcp) from VB 6 using ADO (data control) and Informix CLI 2.30TC1. I have set the Provider to Microsoft OLE DB for ODBC. I have 90 000 records and VB creates a client side cursor on the PC. Problem : Its bloody slow. I have tried to change the data control cursor type to a server side cursor which I assume will be a lot faster (It is using RDO anyway) but cannot get any data to display in my grid with this type of cursor. What am I doing wrong and how can I speed the data access up? What other possible techniques can I use to do data Access? Thanks in advance Steve Weiss