Re: [Firebird-devel] Metadata cache

2013-11-05 Thread Dimitry Sibiryakov
05.11.2013 7:56, Alex Peshkoff wrote: What we sooner save here are CPU cycles required to read data from OS an interpret them. Theoretically, it would allow you to get rid of problems with metadata synchronization and improve metadata versioning. Client connection will see new SPs, for

Re: [Firebird-devel] Performance regression with 3.0.0.30708

2013-11-05 Thread Vlad Khorsun
On 4-11-2013 11:09, Vlad Khorsun wrote: I have a desktop, database is written to a RAID-0 (striped). Could you made events trace with ProcessMonitor ? https://www.dropbox.com/s/gzwppacaya1qyme/ProcMon_FB_CreateDatabase.7z Is this sufficient? Yes, thanks. Seems i found the

Re: [Firebird-devel] Performance regression with 3.0.0.30708

2013-11-05 Thread Alex Peshkoff
On 11/05/13 14:48, Vlad Khorsun wrote: - while database creation is not complete don't flush it until completion Opinons ? This change seems to be absolutely safe no matter of what more performance optimizations we will try later.

Re: [Firebird-devel] Performance regression with 3.0.0.30708

2013-11-05 Thread Dmitry Yemanov
05.11.2013 14:56, Alex Peshkoff wrote: This change seems to be absolutely safe no matter of what more performance optimizations we will try later. I'd also start with this solution first. Dmitry -- November

[Firebird-devel] Firebird 3 snapshots and editline

2013-11-05 Thread Dimitry Sibiryakov
Hello, All. Is isql in snapshots at http://web.firebirdsql.org/download/snapshot_builds/win/ built with or without editline? I ask because of this issue: http://www.sql.ru/forum/1057279-a/firebird-3-0-isql-i-skript-v-kodirovke-dos866 -- WBR, SD.

Re: [Firebird-devel] Firebird 3 snapshots and editline

2013-11-05 Thread Alex Peshkoff
On 11/05/13 18:26, Dimitry Sibiryakov wrote: Hello, All. Is isql in snapshots at http://web.firebirdsql.org/download/snapshot_builds/win/ built with or without editline? I ask because of this issue: http://www.sql.ru/forum/1057279-a/firebird-3-0-isql-i-skript-v-kodirovke-dos866

Re: [Firebird-devel] Firebird 3 snapshots and editline

2013-11-05 Thread Dimitry Sibiryakov
05.11.2013 15:36, Alex Peshkoff wrote: Windows builds do not use editline, windows has native support for same feature. In this case I cannot reproduce isql behaviour with the same fgets-vfprintf pair. In isql sources I see nothing that can change console code page. Most likely I

[Firebird-devel] gcc version for FB3 builds on SF

2013-11-05 Thread Alex Peshkoff
Hello all! It's time to decide what gcc version will be used as basic for FB3 builds. A1 was built using same compilers as 2.5, but this is IMO not a good option for future builds. Currently I see the following choices - use of something like gcc 4.6.4, which is not extra-fresh, but builds

Re: [Firebird-devel] gcc version for FB3 builds on SF

2013-11-05 Thread Philippe Makowski
Le 05/11/2013 16:21, Alex Peshkoff a écrit : Hello all! It's time to decide what gcc version will be used as basic for FB3 builds. A1 was built using same compilers as 2.5, but this is IMO not a good option for future builds. Currently I see the following choices - use of something like gcc

Re: [Firebird-devel] Metadata cache

2013-11-05 Thread Jim Starkey
On 11/1/2013 6:49 AM, Alex Peshkoff wrote: On 10/29/13 20:01, Dimitry Sibiryakov wrote: Hello, All. Did someone try to cut subj off and feed metadata from system tables directly every time when they are needed? May be Jim? About 25 or more years ago :) NFW. That's crazy. All

Re: [Firebird-devel] Changes with handling DB_KEY?

2013-11-05 Thread Jim Starkey
Jaybird? Now that is confusing. Jaybird was the DEC internal code name for what became Rdb/ELN, the immediate precursor to what became Interbase. On 8/4/2013 8:39 AM, Mark Rotteveel wrote: Has anything changed in Firebird 3.0 with the stability of RDB$DB_KEY or how RDB$DB_KEY works? Jaybird

Re: [Firebird-devel] gcc version for FB3 builds on SF

2013-11-05 Thread Alex Peshkoff
On 11/05/13 20:22, Philippe Makowski wrote: Le 05/11/2013 16:21, Alex Peshkoff a écrit : Hello all! It's time to decide what gcc version will be used as basic for FB3 builds. A1 was built using same compilers as 2.5, but this is IMO not a good option for future builds. Currently I see the