The string pool keeps up to 10,000 objects by default. You can modify this
in the ValuePool class. Each time the pool gets filled, a bunch of the least
recently used strings are cleared to make way for new strings.
I'm hoping to add SET PROPERTY commands to change the pool sizes or to clear
them via SQL.
It may also be that your memory is (partly) released but not garbage
collected by the JVM.
Fred
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: 08 December 2003 09:27
Subject: [Hsqldb-user] [REPOST] About the HSQLDB pool of String and Co.
Hi,
It's me again :-)
After fighting with indexes and insert statements, I've got a little
problem,
here it is:
I've got about 1,000,000 lines in a CSV file that I load into a table in
memory
(it takes around 900Mb of memory using the HSQLDB's pool of String).
After that, I convert my data from external codes (String) into internal
codes
(int / Integer). The amount of memory used grows up to 1,2Gb! I then
execute
a delete on the table that contains the external codes hoping to get 900Mb
back
but It doesn't work :-(
Well I don't know how the HSQLDB's pool of String works but I would like to
know
if it is possible:
- to use it directly from other Java class
- to smartly clear it (in my example, only the String used in the external
table...)
- to know how it works :-)
TIA,
Loïc
This message and any attachments (the "message") is intended solely for the
addressees and is confidential.
If you receive this message in error, please delete it and immediately
notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole or partial, is
prohibited except formal approval.
The internet can not guarantee the integrity of this message. BNP PARIBAS
(and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le "message") sont etablis
a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce message par erreur,
merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce message non conforme a
sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf autorisation
expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses filiales)
decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=ick
_______________________________________________
Hsqldb-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
