Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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


.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

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://944660]
NodeReaper selects a flavor of Kool-Aid

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2018-06-23 20:06 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (125 votes). Check out past polls.