Re: AHHH intersolve odbc are slow !!!

sabba <sabba@inrete.it> wrote: :well listen ... there is an informix 7.0 database... there is i-connect :7.2 on the client side .. and intersolve odbc drivers 2.5 .. :i connect to an informix table that has 18 fields .. about 182 bytes :each record .. ok .. :it takes about 2 minutes just to open the table and fetch the firsts 226 :records ?!?! .. : :does anyone knows if there is some configuration parameter i can work on :.. or i just have to throw intersolve odbc drivers ... :if so .. which one do u suggests ?! .. i know openlink .. sco vision ... :but i didn't tested them. (openlink lite works with i-net 5.x .. and i :have 7.2 .. so i have to wait the guys there upgrade their drivers)... :do u think that the best solution for performances is to bypass :informix softare .. ( that is i-star & i-connect ) and use odbc drivers :that needs their own software on the server side as well ?! Yes. (Se my other responces to your posts for more info.) :thank u for the feedback : :sabba Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org