saving/loading memory table to disk/memory

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 39
Joined: Wed 11 Feb 2009 09:42

saving/loading memory table to disk/memory

Post by pwatel » Sun 27 Jul 2014 09:05

I have 2 datamodules one connected to a disk sqlite another is a in memory db
I know I can use the batchmove component to go back and forth between 2 tables
but it is very slow compared to the sqllite dll engine.
a) any way to optimize this approach?
b) is there another way ?
like attaching a memory db to the disk connection and using insert queries withing that same connection
Thank you

Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: saving/loading memory table to disk/memory

Post by AlexP » Mon 28 Jul 2014 08:21


You can transfer data using the TLiteLoader component - the sqlite engine will be used for transfer. You can also work with several SQLite databases in one TLiteConnection and implement data transfer by yourself. For this, you should use the ATTACH DATABASE feature of SQLite: .

Post Reply