Mike,
Thank you very much for your useful reply.
the way to do this is to use a second db instance, open it to
:MEMORY:, and
copy the data (once) to this new db. then, you will have a RAM-based
db,
which should be fast.
Yes, this is what I was hoping to do with the first method. Thanks -
I'll
>
> - set the pragma "temp_store" to MEMORY
> - CREATE TEMPORARY VIEW temp_table AS ()
>
> I am assuming that temp_table is completely in memory, and any queries
> against it will not go back to the disk. Since the table itself is
> small, I am hoping that the overhead of reading the entire table
2 matches
Mail list logo