Using an in-memory database. Not using a journal. Insert all data in an identical in-memory temporary "data2" table, and using INSERT INTO SELECT FROM . Create, afterwards fill a normal table and create an index afterwards.

Thank you
Application Developer
mobile app development company in dallas
AppVerticals