Re: Change table status
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
Try executing a checkpoint after each run of the statement. Fred On Wed, Mar 19, 2014, at 22:20, Bayless Kirtley wrote: 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: [1]Fred Toussi Sent: Wednesday, March 19, 2014 3:06 AM To: [2]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! [3]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [4][email protected] [5]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 - [6]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! [7]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [8][email protected] [9]https://lists.sourceforge.net/lists/listinfo/hsqldb-user References 1. mailto:[email protected] 2. mailto:[email protected] 3. http://p.sf.net/sfu/13534_NeoTech 4. mailto:[email protected] 5. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 6. http://www.avg.com/ 7. http://p.sf.net/sfu/13534_NeoTech 8. mailto:[email protected] 9. 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