[Date Index] [Thread Index] [Author Index]

Database memory usage

• To: mathgroup at smc.vnet.net
• Subject: [mg109418] Database memory usage
• From: Rui <rui.rojo at gmail.com>
• Date: Mon, 26 Apr 2010 07:31:49 -0400 (EDT)

I'm new to databases.
I want to put a big list in a database, to later work on it.
It all worked fine, using the default hsqldb that comes in
Mathematica, but I couldn't insert more than few thousand elements at
a time, and then Link problems or java heap problems.
Finally, I couldn't even open the connection. Java runs out of memory.
Memory usage of javaw process is less than 300MB when it runs out.
In any case, I thought that the databases were, or could be, stored in
the disk, so they can really be big and be a real big advantage over
the list. How can that be done?
If the question is too newbie and you feel I need to read a tutorial
on something, hehe, feel free to send me a link to a good one, hehe

Rui Rojo