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 : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] De la part de Sathya
> Envoyé : mercredi 15 mai 2013 11:45
> À : u2-users@listserver.u2ug.org
> 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
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to