Faster bulk inserts in sqlite3?
- by scubabbl
I have a file of about 30000 lines of data I want to load into a sqlite3 database. Is there a faster way that generating insert statements for each line of data?
The data is space delimited and maps directly to the sqlite3 table. Is there any sort of bulk insert method for adding volume data to a database?
Has anyone devised some deviously wonderful way of doing this if it's not built in?
I should preface this by asking is there a c++ way to do it from the API?
Thanks.