Data Persistence

Mike Bonner bonnmike at gmail.com
Mon Jul 30 18:14:03 EDT 2018


No, the memory db is in memory, the file db is still a file.  Also forgot,
you should probably quote the filename 'pathtofile.db' otherwise it gets
confused (unless you use a file with no extension.

The nice thing about this is you can have your nice persistent file db,
open a memory db, then do a create table main.tablename as select * from
attachedtable.tablename at which point you have the speed benefits of using
an in memory database.  Just gotta keep both updated if you make changes
that need to be persistent, but thats no different than loading an array,
and having to keep the disk based encoded array up to date with changes.
Faster if anything since you don't have to write the whole thing every time.

On Mon, Jul 30, 2018 at 3:46 PM Bob Sneidar via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Interesting... does it load the file database into memory?
>
> Bob S
>
>
> > On Jul 30, 2018, at 08:19 , Mike Bonner via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > Doh. Been a bit since I did it. Its-- ATTACH DATABASE pathtodb.db as
> dbname
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list