Delete columns... How?

Peter Haworth pete at lcsql.com
Tue Sep 30 23:35:25 EDT 2014


Hi Mke,
Don't recall if this is an SQLite database in question but if so, there are
various PRAGMA statements that control caching, page size etc.  Check out
www.sqlite.org for more info.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Tue, Sep 30, 2014 at 11:12 AM, Michael Doub <mikedoub at gmail.com> wrote:

> I think that puts the whole database (multiple tables) in memory.   Bob
> mentioned only the table so I thought he might know of some other magic
> incantation.  :-)
>
> -= Mike
>
>
> On Sep 30, 2014, at 12:05 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
>
> > On Mon, Sep 29, 2014 at 3:58 PM, Michael Doub <mikedoub at gmail.com>
> wrote:
> >
> >> Bob, how do you control whether SQLite pages the table in from disk or
> >> maintains it entirely in memory?
> >>
> >
> > use :memory: as the file name.  Blindingly fast.
> >
> >
> >
> > --
> > Dr. Richard E. Hawkins, Esq.
> > (702) 508-8462
> > _______________________________________________
> > 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
>
>
> _______________________________________________
> 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