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
LiteDump restoring very slow .
Re: LiteDump restoring very slow .
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.
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.