Ravi, Why don't you just cut out the perl/java part of the process and just create a view form over the table in the database? If it is in a different database, you can create a database link. It seems to me that you are duplicating work. It seems from what you said that you are most likely just using that data as a look up by other forms. I believe a view form would work well from what I can see.
HTH, Brian On Wed, Jul 30, 2008 at 10:47 AM, Ravi <[EMAIL PROTECTED]> wrote: > Hi: I have a application which puts data into a oracle table. A perl script > takes the data from the oracle table and submits it to a single form in > Remedy using ARS Perl. The application that puts the data into oracle table > is a single threaded application and puts about 1500 records in 5 minutes > one at a time. But the ARS perl script takes about 45 minutes to an hour. > The form the script is putting the data is a single form with no filters > acting on that form. > > Will migrating the ARS Perl code to JAVA API improve the performance? Any > other suggestions. > > Thanks > Ravi > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
