LiteDump restoring very slow .

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sandokhane
Posts: 3
Joined: Thu 14 Apr 2011 07:00

LiteDump restoring very slow .

Post by sandokhane » Sat 25 Jul 2020 13:30

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
Image

Part of sql script created with sqlite maestro software.
Image

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

MaximG
Devart Team
Posts: 1438
Joined: Mon 06 Jul 2015 11:34

Re: LiteDump restoring very slow .

Post by MaximG » Tue 28 Jul 2020 14:06

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.

Post Reply