You can tell SQLite to disable syncing and journalling, it should get
very fast then:
if session.connection().dialect.name == 'sqlite':
session.connection().execute("PRAGMA synchronous=OFF")
session.connection().execute("PRAGMA journal_mode=OFF")
Of course, your data will be corrupted if the load doesn't exit
cleanly, but for the initial inserts it's not that important -- you
can just delete the DB and start again.
SQLite pragma docs are here: http://www.sqlite.org/pragma.html
On Mon, Jun 17, 2013 at 4:06 PM, Richard Gerd Kuesters
<[email protected]> wrote:
> hi!
>
> curiosity [that may help me, lol]: is there a way to create a sqlite
> database in memory, then save it to disk after initial inserts are done?
> let's say I have around 2 gb of data to insert and ... it takes like
> forever. i still have not convinced my boss to buy a ssd, so ... :D
>
>
> cheers,
> richard.
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
