Phil Sherrod wrote:
> I have an application that requires creating a database with about 50
> million records.  Is there any way to turn off journaling and rollback
> during the creation? I am willing to sacrifice reliability for speed in this
> situation.
>   
Do you know that the performance without doing anything special is 
unacceptable?

Can you do trial runs with increasing fractions of the data to see?

You might be pleasantly surprised. Just be sure to have large numbers of 
insertions in each transaction.

Gerry


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to