Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
Create local in-memory table from server table |
Sat, Jan 18 2014 11:56 AM | Permanent 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 PM | Permanent Link |
Raul 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 PM | Permanent 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 > > > |
This web page was last updated on Thursday, April 18, 2024 at 10:42 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |