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

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
[download]

sqlite3 mydb.db < commands.txt

Comment on Re^5: Index a file with pack for fast access Download Code

Replies are listed 'Best First'.
Re^6: Index a file with pack for fast access by BrowserUk (Patriarch) 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?	[reply]

Replies are listed 'Best First'.

Re^6: Index a file with pack for fast access
by BrowserUk (Patriarch) 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?

[reply]

In Section Seekers of Perl Wisdom