As mentioned the other day, another time factor on inserts is how
you commit. The default AutoCommit is often expensive; but you
also don't want to go the extreme other end and commit only at the
end. I often use counters and tune the commits to N lines; where
I find a value for N that's optimal. For command line scripts I
usually provide this as a command line option with some reasonable
default.
----
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
> -----Original Message-----
> From: Greg Wardawy [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 15, 2001 3:33 PM
> To: [EMAIL PROTECTED]
> Subject: RE: How can I speed it up?
>
> Yes, using placeholders dramatically increased the speed. I had no time
> to apply and test all Mitch's suggestions except optimizing the regex and
> moving 'no warnings' outside the loop but I'm working on it. Strange,
> inserting 100K records with placeholders and 'no warnings' outside the
> loop takes 26 min, with placeholders and 'no warnings' inside the loop it
> takes 15 min. But I've tested it just one time (using my stopwatch - not
> too sophisticated method) so it can be a db server and/or network issue.
> Thanks again.
> Greg
>
> >>> "Sterin, Ilya" <[EMAIL PROTECTED]> 06/15/01 01:40PM >>>
> What exactly did you change. Just used placeholders? If yes, we can use
> this as an example for anyone else here, since this is a tremendous time
> change.
>
> Ilya
>
> -----Original Message-----
> From: Greg Wardawy
> To: [EMAIL PROTECTED]
> Sent: 06/15/2001 12:32 PM
> Subject: Re: How can I speed it up?
>
> Thanks a lot. It's much better now - inserting 100K records takes just
> 26 min.
> Greg
>
