Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly !
Elsewhere, For performance, set a index on the @id Why do you want to use save-list/get-list ? You can work on LIST1 directly ! manu > -----Message d'origine----- > De : [email protected] [mailto:u2-users- > [email protected]] De la part de Sathya > Envoyé : mercredi 15 mai 2013 11:45 > À : [email protected] > Objet : [U2] select query.. > > 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
