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
<[email protected] <mailto:[email protected]>> 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
<[email protected]> 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 [email protected].
To post to this group, send email to
[email protected].
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 [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
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 [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
