Well let me try.
Learn to think for yourself.
It can take you far.
It took us to the moon.
- Rami
On 18-May-17 23:36, Kerry Sainsbury wrote:
Sorry, I can't help further.
On 19 May 2017 at 03:58, Narendran Balasubramaniam
<narenb...@gmail.com <mailto:narenb...@gmail.com>> wrote:
We have only around 4 tables and dont have foreign key references
between them, so deleting older db is not a problem. Let me know
if there is still a option to split date wise.
Also thought about the other solution you provided ( Creating
daily db ), but we have a UI where a date range based is provided.
User can select a week or month range and data should be shown for
that.
In case we create daily db, is there a option to combine data from
DB of different dates and perform search on that.
Thanks,
Naren.
On Wednesday, May 17, 2017 at 7:01:45 PM UTC-4, Kerry Sainsbury
wrote:
As you observe, the documentation doesn't talk about it. Where
did you see it mentioned? I can't really even imagine how it
would work; what happens to 'today' rows that have a foreign
key reference to a 'yesterday' row when you delete the
'yesterday' files? Eek!
Given your actual objective I'd guess you can create a fresh
database each day, named using 'todays' date, and
programmatically delete the 'old' ones.
On 18 May 2017 at 09:48, Narendran Balasubramaniam
<nare...@gmail.com> wrote:
Hi,
Can someone let me know how to split H2 DB files based on
date ( daily files ). Checked H2 documentation and it
currently shows option to split based on Size.
Objective is to backup older dated files after a period of
time and save storage space.
Thanks,
Naren
--
You received this message because you are subscribed to
the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to
h2-da...@googlegroups.com.
Visit this group at
https://groups.google.com/group/h2-database
<https://groups.google.com/group/h2-database>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to h2-database+unsubscr...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at https://groups.google.com/group/h2-database
<https://groups.google.com/group/h2-database>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to h2-database+unsubscr...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.