Thats awesome..Thanks guys.. -Naren
On Thursday, May 18, 2017 at 5:14:10 PM UTC-4, Rami Ojares wrote: > > 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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > 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.
