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 <nare...@gmail.com > <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 <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. >>>> 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...@googlegroups.com <javascript:>. >> To post to this group, send email to h2-da...@googlegroups.com >> <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 h2-database...@googlegroups.com <javascript:>. > To post to this group, send email to h2-da...@googlegroups.com > <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 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.
