Sorry, I can't help further. On 19 May 2017 at 03:58, Narendran Balasubramaniam <[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. >>> 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. > -- 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.
