Devart Forums

Hello ...i am trying Litedump .. but i see tha the restoring is very slow ...
and backup methode create an sql script with one INSERT statement for EACH ROW...i think that is the problem...
because when using SQL SCRIPT created with SQLITE MAESTRO the restoring is very fast ..because the script contain ONLY ONE INSERT statement for the whole table.

Part of sql script created with Backup method


Part of sql script created with sqlite maestro software.


here is my example test project.
https://mega.nz/file/Fch0xILL#U49lQy-XM ... e0Z2JNbr20

The TLiteDump component is designed to generate SQL scripts for creating database objects and inserting data into them. You can also use the script to restore the database. TLiteDump is not designed for high-speed inserts.
We have a dedicated component TLiteLoader for high-speed inserts: https://www.devart.com/litedac/docs/dev ... loader.htm. You can leave your feature suggestions on our UserVoice page: (https://devart.uservoice.com/forums/104 ... y_id=18931). If your suggestion receives many upvotes, we'll implement the feature.