Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Create local in-memory table from server table
Sat, Jan 18 2014 11:56 AMPermanent Link

John Taylor

DBisam 4 Client-server...

Is there a quicker way to create a local in memory table to be used in
filtering, searching, etc.  than opening a query on the server table and
iterating
through each record and inserting into the local in-memory table ?

Tips appreciated!

JT


Sat, Jan 18 2014 12:31 PMPermanent Link

Raul

Team Elevate Team Elevate

On 1/18/2014 11:56 AM, John Taylor wrote:
> DBisam 4 Client-server...
>
> Is there a quicker way to create a local in memory table to be used in
> filtering, searching, etc.  than opening a query on the server table and
> iterating
> through each record and inserting into the local in-memory table ?

See SaveToStream/LoadToStream

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Loading_Saving_Streams

Basically you'd use "SaveToStream" on remote table and then
"LoadToStream" into in-memory table.

This is a memory operation so ideally your tables are not massive - and
in your case you'll consume twice the memory even since you'll have the
stream and in-mem table active at the same time for a bit.

Raul
Sat, Jan 18 2014 3:08 PMPermanent Link

John Taylor

Thank you !, perfect.

JT

"John Taylor" <jcta@snappysoftware.com> wrote in message
news:ACECBFB7-9824-416C-8AA1-A890BC08A079@news.elevatesoft.com...
> DBisam 4 Client-server...
>
> Is there a quicker way to create a local in memory table to be used in
> filtering, searching, etc.  than opening a query on the server table and
> iterating
> through each record and inserting into the local in-memory table ?
>
> Tips appreciated!
>
> JT
>
>
>
Image