Re: Change table status
"Bayless Kirtley" <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <A6002BE2862B4D54B98AF3E5D0F06939@Tiger> |
Fred, it worked on 1 table but I have 4 that need to be changed. I tried several times, all at once and one at a time and those other 3 will not change. Any idea what may be wrong? Bayless From: Fred Toussi Sent: Wednesday, March 19, 2014 3:06 AM To: User discussions about HyperSQL Database Engine. Subject: Re: [Hsqldb-user] Change table status Yes, Execute the following one each large table, and leave the smaller tables as they are: SET TABLE mytable TYPE CACHED Fred On Tue, Mar 18, 2014, at 20:46, Bayless Kirtley wrote: Is it possible on an existing database to change a memory table to a cached table? I have some that have grown much larger than expected. Bayless ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user -------------------------------------------------------------------------------- ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech -------------------------------------------------------------------------------- _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user -------------------------------------------------------------------------------- No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4336 / Virus Database: 3722/7213 - Release Date: 03/18/14 ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user