Re: Change table status
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
Do you get an error message? In any case execute the DatabaseManager with a large Xmx memory allocation. Fred On Mon, Mar 24, 2014, at 19:09, Bayless Kirtley wrote: Hmmm. Still no luck. I opened with DatabaseManager and manually submitted the SET TABLE statements as you suggested. The 3 recalcitrant table are still memory instead of cached. From: [1]Fred Toussi Sent: Friday, March 21, 2014 5:08 PM To: [2]User discussions about HyperSQL Database Engine. Subject: Re: [Hsqldb-user] Change table status This doesn't look right. You don't need to recompile your code to upgrade from 2.2.8. If the properties file is showing 2.2.8, the version of HSQLDB that last saved the database is 2.2.8 Regarding the actual issue, open a copy of your database with the DatabaseManager and enter the SET TABLE statements by hand to see they do indeed work. Fred On Thu, Mar 20, 2014, at 2:26, Bayless Kirtley wrote: Fred, I just tried the checkpoint. Also tried commit then shutdown after each set command. Still no luck. One table changes but the other 3 are still memory. I am still running 2.2.8 so thought I would update to 2.3.2. Everything still the same. But, after that, my .properties file still shows 2.2.8. The way I tried to update was remove the old library from my program then point to the new one and recompile. This is an imbedded database. Am I doing something wrong in my update method? Bayless From: [3]Fred Toussi Sent: Wednesday, March 19, 2014 5:24 PM To: [4]User discussions about HyperSQL Database Engine. Subject: Re: [Hsqldb-user] Change table status 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: [5]Fred Toussi Sent: Wednesday, March 19, 2014 3:06 AM To: [6]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! [7]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [8][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 __________________________________________________________________ No virus found in this message. Checked by AVG - [10]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! [11]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [12][email protected] [13]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 - [14]www.avg.com Version: 2014.0.4336 / Virus Database: 3722/7217 - Release Date: 03/19/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! [15]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [16][email protected] [17]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 - [18]www.avg.com Version: 2014.0.4336 / Virus Database: 3722/7227 - Release Date: 03/21/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! [19]http://p.sf.net/sfu/13534_NeoTech _______________________________________________ Hsqldb-user mailing list [20][email protected] [21]https://lists.sourceforge.net/lists/listinfo/hsqldb-user References 1. mailto:[email protected] 2. mailto:[email protected] 3. mailto:[email protected] 4. mailto:[email protected] 5. mailto:[email protected] 6. mailto:[email protected] 7. http://p.sf.net/sfu/13534_NeoTech 8. mailto:[email protected] 9. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 10. http://www.avg.com/ 11. http://p.sf.net/sfu/13534_NeoTech 12. mailto:[email protected] 13. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 14. http://www.avg.com/ 15. http://p.sf.net/sfu/13534_NeoTech 16. mailto:[email protected] 17. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 18. http://www.avg.com/ 19. http://p.sf.net/sfu/13534_NeoTech 20. mailto:[email protected] 21. 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