Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: SQLite and CPU Usage

by paulbort (Hermit)
on Aug 03, 2004 at 17:58 UTC ( #379764=note: print w/replies, xml ) Need Help??


in reply to SQLite and CPU Usage

All of the suggestions about batch inserts are right on, I would just like to add one minor point since you mentioned indexes: If you are going to need the indexes later, it is usually faster to build the indexes after all the inserts are done, becaus this minimizes the number of times that index pages have to be re-arranged.

--
Spring: Forces, Coiled Again!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://379764]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2019-07-24 02:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If you were the first to set foot on the Moon, what would be your epigram?






    Results (32 votes). Check out past polls.

    Notices?