Performance tunning in Gel Script?

[Anon Anon]

Is there any way to improve the performance of Gel Script? Currently gel script is taking 5-6 mins but need to bring down to 5-10 secs  and the basic structure of gel script is as follows:    xmlns:SOAP-ENV=" http://schemas.xmlsoap.org/soap/envelope/ "  xmlns:core="jelly:core"  xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"  xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"  xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/ "  xmlns:sql="jelly:sql" xmlns:xog=" http://www.niku.com/xog "  xmlns:xsd=" http://www.w3.org/2001/XMLSchema "  xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance ">                                   Please let me know in case of any issues.  Thanks,Job

[Anon Anon]

You don't give us much information as what to tune!   :-)  --  However, I would start by constructing an "empty" GEL script (one that does nothing) - how long does that take to run, if that is 5-6 minutes then you have an issue in your "architecture".  If that "empty" script runs immediately, then you have issues in one of the (many) steps in your pseudo-code above.  So add the real code in one-section-at-a-time to work out where your bottle-neck is.....  I would guess it might be in any SQL logic you have therein, or at the XOG-call itself.....  ??  David MortonCapgemini

[Anon Anon]

Agree fully with Dave. Not much to go on and piece by piece is a good tip.            What is this first XOG for? Can this be achieved by a SQL query?       Why are you writing to file? Could this be the bottleneck? (if so: may be impacting more than this 1 script)  

[Anon Anon]

Gurus,  Is this actions (XOG activities) captured in any system tables currently .Like an table which will be showing    id   -   5xxxxxxxaction - "xog read - project "sucess - yes/noduration -   15 secsrecords - updated -15object - 'project'  update by - adminupdate date - '04-nov-2009'  cheers,sundar      

[Anon Anon]

Hi,  Time taken is really depends upon what are you trying to achieve out of this script. for example if you are trying to XOG in the prject having 100 tasks and 100 team members will take much more time than to XOG only project name and ID without any team member or task.Also, it may be  very if  SQL queries are included in the script. In that case database performance alos comes into the picture and of course if the query itself takes more time to fetch the resultset from the database.  Once I used for loop to XOG in ( adding) team members to the project one by one it took 30 mins to complete the process. Instead  I clubed all the resources in one tag and XOGed that in took 2 mins.So in conclusion it depends upon the logic which is writen in the script which takes time and can be tuned in that way.  BEst wishes,Swapnil