Welcome to the Monastery | |
PerlMonks |
Re:x3 It works, it's fast, and it's scalable!by grinder (Bishop) |
on Jan 25, 2002 at 14:58 UTC ( [id://141467]=note: print w/replies, xml ) | Need Help?? |
My main objective to this thread was that I was looking for a way to populate CLS_TMP_$$ very quickly. I didn't want to do something silly like this:because each query would then do a COMMIT, making it VERY slow. Are we still talking about DBI here? It so, why not just create a db handle with {Autocommit => 0} so that it doesn't perform a commit on each insertion. Insert the x thousand records, and do a single commit at the end. You might also want to drop the indexes before the insert, and then create the index after all records have been inserted. Of course, I'm sure you know all of this already. --g r i n d e r
|
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re:x3 It works, it's fast, and it's scalable!
by joealba (Hermit) on Jan 25, 2002 at 20:00 UTC | |
by pmas (Hermit) on May 28, 2002 at 19:36 UTC | |
by joealba (Hermit) on May 28, 2002 at 20:51 UTC |
Log In? |
---|
Domain Nodelet? |
Node Status? |
node history Node Type: note [id://141467] help |
Chatterbox? |
How do I use this? • Last hour • Other CB clients |
Other Users? |
Others imbibing at the Monastery: (3) As of 2024-04-26 03:47 GMT |
Sections? |
Information? |
Find Nodes? |
Leftovers? |
|
Voting Booth? |
No recent polls found |