how to copy a table from disk to memory

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

how to copy a table from disk to memory

Post by pwatel » Mon 09 Jun 2014 04:41

Hello
I want to have a in memory table to be fed by a table residing on the disk
what is the way to go please to make it as fast as possible
thank you

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

Re: how to copy a table from disk to memory

Post by AlexP » Tue 10 Jun 2014 08:10

Hello,

There is no "memory" table in SQLite. You can either use temporary table or connect to memory database ( LiteConnection.Database := ':memory:') and copy your table. More details about temporary table and memory Database can be found in the documentation at sqlite.org .

Post Reply