Re: Array fetch using cursor

Peter Lancashire wrote: > > venugopal gangadharan wrote: > > > > Hi, > > Hi , > > I want to know how an array fetch can be done from a table in an > > Informix DB using a cursor > > > > My Problem:- > > total records in the table :- 120000 > > Processing done :- > > fetch records one at a time and write into a binaryfile > > TimeTaken :- > > around 14 mins > > > > > > > > can any one help me on this , > > IS there any other way to tune up the fetch > > > > thankyou > > > > Venu. > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com > > I think you can increase the buffer size used by cursors in ESQL/C. My > memory is unreliable (loose connections) so please check. Check out the Array Fetch code in my dbcopy.ec utility in utils2_ak in the IIUG Software Repository for a sample code. Dbcopy uses increased buffer size along with the Fetch Array feature to run 3X faster than the original version. Disabling Fetch Array and only using the increased buffer size (command line parameters) improves performance about 20% over disabling both. Art S. Kagel