RE: [firebird-support] firebird schema changes during backup

2017-01-23 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> On Mon, 23 Jan 2017 15:48:15 -0500 Dimitry Sibiryakov > mailto:s...@ibphoenix.com [firebird-support] supp...@yahoogroups.com> wrote > > Changing metadata is a bad idea in general. > Continuous development is the worst thing that can happen to a database. > > >

Re: [firebird-support] Full join and indices

2017-01-23 Thread setysvar setys...@gmail.com [firebird-support]
Den 23.01.2017 13:05, skrev Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]: Hi, I just needed to do a full outer join between two very simple tables G and N, each with a single-column PK of identical type char(12). I noticed that the plan produces was: PLAN JOIN (N

Re: [firebird-support] firebird schema changes during backup

2017-01-23 Thread DougC d...@moosemail.net [firebird-support]
On Mon, 23 Jan 2017 15:48:15 -0500 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] firebird-support@yahoogroups.com wrote Changing metadata is a bad idea in general. Continuous development is the worst thing that can happen to a database. And that is the

Re: [firebird-support] firebird schema changes during backup

2017-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2017 21:36, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > For all that, I don't think it is a good idea to be changing metadata > during a backup. Changing metadata is a bad idea in general. Continuous development is the worst thing that can happen to a database. --

Re: [firebird-support] firebird schema changes during backup

2017-01-23 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello , Monday, January 23, 2017, 11:08:40 PM, kragh.tho...@yahoo.com wrote: > On a product of ours we use continuous deployment where code and > database schema changes is deployed quite often. Sometimes we would > like to make a new release during database backup. So my questions are: > 1)

[firebird-support] Re: Full join and indices

2017-01-23 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
23.01.2017 15:05, Kjell Rilbe wrote: > > I'm still on FB 2.5.2, so... has this been improved in 3.0? Yes, it was (to some extent). Dmitry

[firebird-support] Full join and indices

2017-01-23 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi, I just needed to do a full outer join between two very simple tables G and N, each with a single-column PK of identical type char(12). I noticed that the plan produces was: PLAN JOIN (N NATURAL, G NATURAL) I stopped the query after ~5 minutes. Then I thought I can do this calculation

[firebird-support] firebird schema changes during backup

2017-01-23 Thread kragh.tho...@yahoo.com [firebird-support]
Hey On a product of ours we use continuous deployment where code and database schema changes is deployed quite often. Sometimes we would like to make a new release during database backup. So my questions are: 1) How does Firebird handle schema changes during backup? 2) And is it safe to