RE: [sqr-users] Insert -SQR

["Katrina Trescott" <katrina_trescott@excite.com>]

 I am new to SQR.  I am having a terible time with BEN100. Please provide an 
example of the timer routine.Thanks,Katrina Trescott--- On Thu 10/31, Knapp, 
Richard < KnappR@umsystem.edu > wrote:From: Knapp, Richard [mailto: 
KnappR@umsystem.edu]To: sqr-users@sqrug.orgDate: Thu, 31 Oct 2002 13:46:23 
-0600Subject: RE: [sqr-users] Insert -SQRHi Lisa,I agree with your consultant 
on dropping and rebuilding the indexes. Also, make sure you use indexed fields 
for your joins and use as many of them as possible in both main and sub 
queries.I have had some success speeding things up in loading values from small 
tables used for lookup into arrays. You just have to try this to see if it will 
work for you. Put a timer routine in your program and call it from key points 
to see just where the slow up is.Richard KnappDatabase 
Programmer/AnalystInstitutional Research and PlanningUniversity of Missouri 
System573-882-8856knappr@umsystem.edu-----Original Message-----From: Smyth Lisa 
G Contr AEDC/ACS [mailto:Lisa.Smyth@arnold.af.mil]Sent: Thursday, October 31, 
2002 1:31 PMTo: sqr-users@sqrug.orgSubject: [sqr-users] Insert -SQRI inherited 
this program. I have been asked to improve performance becauseit is taking a 
very long time. I have an SQR program that inserts a record into a table with 
over 8 millionrecords, needless to say this is very costly to the 
database(Oracle) asnoted in the EXPLAIN PLAN.. The process reads a record from 
the source table and does some validationsand lookups of additional values and 
then inserts the record into the targettable then repeats the process by 
reading a record from the source table andso on. Someone suggested disabling 
the index while inserting and then rebuilding itafter it is finished inserting. 
Any suggestions would be great or where to go lookup some additional info.I 
have read some of the Oracle Database Performance Guide and Referencematerial. 
Thanks, Lisa Lisa SmythPeopleSoft 
Financials931.454.4861Lisa.Smyth@arnold.af.mil_______________________________________________sqr-users
 mailing 
listsqr-users@sqrug.orghttp://www.sqrug.org/mailman/listinfo/sqr-users_______________________________________________sqr-users
 mailing listsqr-users@sqrug.orghttp://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users