Or what about creating it as a file based db, but on a ram disk,
then copy to actual filesystem once created?
> You called my attention. Are you able to provide any example or a
further explanation on how to do this,
> because this would be more or less the solution I was looking for.
On modern Linux kernels you can simply place your file under /dev/shm
Am 04.08.2012 13:20, schrieb Robin:
Hi,
thank you for your reply.
Can you do a script to, then create it again as a file based
database off the script?
This was the only solution I could imagine as a Work-Around. But I
think it isn't a nice solution, as well as I'm not sure about the
performance?
Or what about creating it as a file based db, but on a ram disk,
then copy to actual filesystem once created?
You called my attention. Are you able to provide any example or a
further explanation on how to do this, because this would be more or
less the solution I was looking for.
With best regards Robin
On Saturday, August 4, 2012 3:40:44 AM UTC+2, Kartweel wrote:
Or what about creating it as a file based db, but on a ram disk,
then copy to actual filesystem once created?
On 3/08/2012 10:14 PM, Robin wrote:
Hi,
For those who are interested in my use case, you may read
this part or skip it:
I need to create a huge DB (300 mb right now, and this is
only some test data. Not at least close to all the Data). To
create this DB I read a CSV file with information that need
to be parsed for my needs. I handle all the DB action with
ORMLite (http://ormlite.com/). The creation of this DB on the
filesystem needs increadibly long (like forever, I stopped
after half an hour). The in-memory will handle it in ~5
minutes. So it will be really important for me to create the
DB in-memory. The DB needs to be reloaded every 1 or 2 weeks,
over the weekend, so it should be finished within a day. But
the created Data has to be used from other programms, so it
won't be very clever to use it in-memory.
is there a possibility to save a h2 in-meory DB to the filesystem
and read it like a regular h2 file DB ? The best would be to do
all this with ORMLite, but this isn't really that important to me.
With best regards Robin
--
You received this message because you are subscribed to the
Google Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/eQfeJqHE07EJ
<https://groups.google.com/d/msg/h2-database/-/eQfeJqHE07EJ>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:[email protected]>.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
<http://groups.google.com/group/h2-database?hl=en>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/ZlyM-Gc9xjsJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
