To speed it up, try resizing the file.
On 15 May 2013 21:44, Sathya <sathya8...@gmail.com> wrote: > Hi Experts.. > > I have one issue here with fetching data from the file. > > EXECLINE = "SELECT FILE.NAME WITH @ID = \":KEYVALUE:"\" > DISPLAY EXECLINE > EXECUTE EXECLINE RTNLIST LIST1 > EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 > > LIST.NAME = "GET-LIST SOME.LIST" > sellist = '' > EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk > > Here Im running a loop for a set of "KEYVALUE"s and for each run the > SSELECT statement is taking around 30 seconds. When I want to run 1000 > loops, ideally the run time will be much. > > Is there any easier way to do this with less time consumption. > > Thanks & Regards, > Sathya V. > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users