tag:blogger.com,1999:blog-25740336.post5642770847335457101..comments2023-08-24T22:26:48.675+01:00Comments on The PeopleSoft DBA Blog: Performance Benefits of ReUse Statement Flag in Application EngineDavid Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-25740336.post-19823276837276476522011-02-17T08:15:14.618+00:002011-02-17T08:15:14.618+00:00These are batch timings. They are enabled by sett...These are batch timings. They are enabled by setting the <i>TraceAE</i> flag 128 to write them to file, and 1024 to the database.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-36101299233013791752011-02-07T20:26:08.791+00:002011-02-07T20:26:08.791+00:00Whats the trace value you would set to derive such...Whats the trace value you would set to derive such timingsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-25740336.post-62709738064973367902009-03-03T04:36:00.000+00:002009-03-03T04:36:00.000+00:00Hi David,I was trying to fine tune my AE, using th...Hi David,<BR/><BR/>I was trying to fine tune my AE, using the tips you have talked about, and I've seen phenomenal improvement in the processing times for my AE. I was initially writing to a file about a million rows in 30 mins, some tweaking and ReUseCursor for CreateSQL got the time down to 3 minutes. I'm now able to successfully write about 11 million rows in a single file in just under 30 mins.<BR/><BR/><BR/>Thanks to you.<BR/><BR/>Cheers!!<BR/>PrashantCiphersbakhttps://www.blogger.com/profile/01586158446874473262noreply@blogger.comtag:blogger.com,1999:blog-25740336.post-73042789464901776092009-02-28T13:26:00.000+00:002009-02-28T13:26:00.000+00:00Hi David,This is a great example to show the ReUse...Hi David,<BR/><BR/>This is a great example to show the ReUse feature of App Engines. Really appreciate your article on it ... <BR/><BR/>Thank You very much<BR/><BR/>Cheers<BR/>Thanks!<BR/>PrashantCiphersbakhttps://www.blogger.com/profile/01586158446874473262noreply@blogger.com