RE: [sqr-users] (no subject)

[James Womeldorf <jwomeldo@fastenal.com>]

Hi Rajesh,
One thing we sometimes do to speed this type of process up is to drop the
indexes on the target tables, then insert the data, and finally rebuild the
indexes.  Of course you have to be careful not to violate any unique
constraints on your tables since the indexes are not there to assist you
while the insertions are made.
Jim

-----Original Message-----
From: RAJESH SAWANT [mailto:rajsaw@hotmail.com]
Sent: Thursday, September 18, 2003 5:29 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] (no subject)



Hi all SQR Gurus,

Which are the different ways to increase the speed of SQR.

We are using SQR for converting legacy large data ( 200,000 rows in a file )
which is taking around 40 minutes to run single SQR.

Since our conversion process contains 25-30 sqrs the total time for running 
all the
sqrs will take a lot of time.

What can be cone at the  database side or by tuning the sqr to reduce the 
time.

Please help me in this.

Thanks,
Rajesh

_________________________________________________________________
A chance to meet Aishwarya Rai. http://www.myenjoyzone.com/msn/knk.php3 Win 
lucky prizes.

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

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