Re: Array fetch using cursor

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. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 -- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/