RE: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
> Hello, > > since 3 days during production the modified date does not chenge, is there a > reason why? Its the right database. This is a Windows issue, it does not update file properties until a file is closed. Since, you haven't closed the database file... Sean
Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
On 11/03/16 13:06, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > As quoted in the documentation in my previous mail, Windows only guarantees > updates of the timestamps when the handle is closed. Which has been the case in windows for 20 years. It is only M$ who could 'fix' this, but as said updating the file details for every write will only further slow the process. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: Re: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
On 2016-03-11 13:49, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >>> 11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl >> [firebird-support] wrote: >> > > i can confirm this - database modified datatime is frozen when >> first connection has started. >> > > i suppose that you should raport ticket into the firebird >> tracker. >> > >> > This ticket rather belongs to Windows tracker. >> > >> > -- >> > WBR, SD. >> > > > Hi, > > is this possible that this is not Microsoft error? It is not an error, it is intentional behavior. Otherwise each and every byte changed inside a file would trigger (and commit) a timestamp modification which is bad for performance, and might lead to wear on the underlying storage (which for example for SSD might be problematic). > e.g some caching (like forced write) i have it enabled and changes > should go into database immidietly > But e. when i delete table definition - database file timestamp has > not changed. > But if i had created big index then DT was changed. That is probably because the first did not add new pages to the database file but only made some changes in existing pages, and the second required addition of new pages which required Windows to allocate additional clusters to the file, and therefor had to update the filesystem information anyway, so it also updated the timestamps. As quoted in the documentation in my previous mail, Windows only guarantees updates of the timestamps when the handle is closed. Mark
Re: AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
On 2016-03-11 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hi, > > my third ticked within three days. What should I do, windows ticket? > E-Mail an microsoft? ;) It is expected behavior. See https://msdn.microsoft.com/en-us/library/windows/desktop/ms724290%28v=vs.85%29.aspx : "Time stamps are updated at various times and for various reasons. The only guarantee about a file time stamp is that the file time is correctly reflected when the handle that makes the change is closed." The difference (in contrast with earlier versions) you might be experiencing with Firebird 3 has likely to do with the new database linger functionality which will keep the file open for a while when there are no connections to that database. See ""Linger" Database Closure for Superserver" in the Firebird 3 release notes. Mark
Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
11.03.2016 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > What should I do, windows ticket? E-Mail an microsoft? ;) Yep. That was their decision to save your HDD by not writing modification time until the file is closed. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: Re: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
> 11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] > wrote: > > i can confirm this - database modified datatime is frozen when first > > connection has started. > > i suppose that you should raport ticket into the firebird tracker. > > This ticket rather belongs to Windows tracker. > > -- > WBR, SD. > Hi, is this possible that this is not Microsoft error? e.g some caching (like forced write) i have it enabled and changes should go into database immidietly But e. when i delete table definition - database file timestamp has not changed. But if i had created big index then DT was changed. regards, karol Bieniaszewski
AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
Hi, my third ticked within three days. What should I do, windows ticket? E-Mail an microsoft? ;) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 11. März 2016 13:26 An: firebird-support@yahoogroups.com Betreff: Re: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2 > 11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl > <mailto:liviusliv...@poczta.onet.pl> [firebird-support] wrote: > > i can confirm this - database modified datatime is frozen when first > > connection has started. > > i suppose that you should raport ticket into the firebird tracker. > > This ticket rather belongs to Windows tracker. > > -- > WBR, SD. > Hi, you have right ;-) regards, Karol Bieniaszewski
Re: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
> 11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] > wrote: > > i can confirm this - database modified datatime is frozen when first > > connection has started. > > i suppose that you should raport ticket into the firebird tracker. > >This ticket rather belongs to Windows tracker. > > -- >WBR, SD. > Hi, you have right ;-) regards, Karol Bieniaszewski
Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > i can confirm this - database modified datatime is frozen when first > connection has started. > i suppose that you should raport ticket into the firebird tracker. This ticket rather belongs to Windows tracker. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
Hello, since 3 days during production the modified date does not chenge, is there a reason why? Its the right database. Thanks. Hi, i can confirm this - database modified datatime is frozen when first connection has started. i suppose that you should raport ticket into the firebird tracker. regards, Karol Bieniaszewski
[firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2
Hello, since 3 days during production the modified date does not chenge, is there a reason why? Its the right database. Thanks.