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
how to copy a table from disk to memory
Re: how to copy a table from disk to memory
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 .
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 .