Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^5: Index a file with pack for fast access

by Anonymous Monk
on Dec 21, 2011 at 16:38 UTC ( #944660=note: print w/ replies, xml ) Need Help??


in reply to Re^4: Index a file with pack for fast access
in thread Index a file with pack for fast access

http://erictheturtle.blogspot.com/2009/05/fastest-bulk-import-into-sqlite.html

commands.txt

.echo ON .read create_table_without_pk.sql PRAGMA cache_size = 400000; PRAGMA synchronous = OFF; PRAGMA journal_mode = OFF; PRAGMA locking_mode = EXCLUSIVE; PRAGMA count_changes = OFF; PRAGMA temp_store = MEMORY; PRAGMA auto_vacuum = NONE; .separator "\t" .import a_tab_seprated_table.txt mytable BEGIN; .read add_indexes.sql COMMIT; .exit

sqlite3 mydb.db < commands.txt


Comment on Re^5: Index a file with pack for fast access
Download Code
Re^6: Index a file with pack for fast access
by BrowserUk (Pope) on Dec 21, 2011 at 16:41 UTC

    Cool! You found it. But try working it out for yourself from the SQLite docs.


    With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.

    The start of some sanity?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2014-12-29 08:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (185 votes), past polls