Re: Change table status
"Bayless Kirtley" <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1EB27C22D9A0426FBABC36146D596634@Tiger> |
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: Fred Toussi
Sent: Friday, March 21, 2014 5:08 PM
To: 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: Fred Toussi
Sent: Wednesday, March 19, 2014 5:24 PM
To: 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: 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
------------------------------------------------------------------------------
------------------------------------------------------------------------------
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/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!
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/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!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user