Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3659) Іncrease table name and field name size above 32 symbols

2011-11-13 Thread Alexandre Benson Smith
Em 13/11/2011 09:13, Dimitry Sibiryakov escreveu: > 13.11.2011 12:09, Kjell Rilbe wrote: >>> Іncrease table name and field name size above 32 symbols for support ORM >>> frameworks sach as Ruby on Rails >> Would be much appreciated, yes. ECO handle's the limitation >> automatically, but a problem

Re: [Firebird-devel] Engine crashes repeatedly when lock table exceeds 2 gigabyte limit

2012-02-12 Thread Alexandre Benson Smith
Em 11/2/2012 19:19, Carlos H. Cantu escreveu: > SM> Sorry, I have no solution for this situation, but I`m curious - what > SM> is the Oracle price for such kind of configurations/projects? > > Well, probably a bunch of money! > > This leads me to think: a customer who saved so much money using FB

Re: [Firebird-devel] Raising the BLR level

2012-03-06 Thread Alexandre Benson Smith
Em 6/3/2012 03:46, Alex Peshkoff escreveu: > > And taking into an account that we do not support ODS< 12 in current > engine - do we need to keep support of old BLR versions? I see 2 ways > for old BLR to arrive in ODS12 database. First of all - when old > database is restored. May be we should le

[Firebird-devel] Optmizer vs IN (sub-select)

2013-01-23 Thread Alexandre Benson Smith
Hi ! It's known that Firebird transforms this kind of query: select TableA.Foo from TableA where TableA.Bar in (select TableB.Bar where X=Y) into: select TableA.Foo from TableA where exists (select * from TableB where where X=Y and TableB.Bar = TableA.Bar) This implies

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-05 Thread Alexandre Benson Smith
Em 4/4/2013 22:53, Doug Chamberlin escreveu: > So forget the previous discussion for a moment. Especially any parts > about the best ways to implement replication and SELECT * problems. > > Without getting into the details of the use case, essentially the OP > asked for a way to suppress the pres

[Firebird-devel] Direct System Table Update

2013-07-17 Thread Alexandre Benson Smith
te (i.e. has no way to achieve using DDL) in 2.5 and what will be changed on 3.0 ? Thank you ! Alexandre Benson Smith -- See everything from the browser to the database with AppDynamics Get end-to-end visibility w

Re: [Firebird-devel] How to? Coordinating transactions for multiple connections in single call

2014-04-01 Thread Alexandre Benson Smith
Sean, Em 1/4/2014 19:59, Leyne, Sean escreveu: > All, > > Consider a large database (200GB, large tables with 450 Million rows) which > is running on a kick-a** server with pool of enterprise SSDs for storage > (more IOPS then Firebird could ever use), which I need to extract data from > on a r

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Alexandre Benson Smith
Em 28/4/2014 18:21, Claudio Valderrama C. escreveu: >> -Original Message- >> From: Carlos H. Cantu [mailto:lis...@warmboot.com.br] >> Sent: Lunes, 28 de Abril de 2014 12:30 >> >> DY> Thanks, but I seemed to explicitly state that plain >> wishlists don't >> DY> count. >> >> It seems that I a

[Firebird-devel] Forced Writes Off x MaxUnflushedWrites x MaxUnflushedWriteTime

2015-08-04 Thread Alexandre Benson Smith
eve a better performance and with MaxUnflushedWrites = 1 each page are written with out reordering. I hope someone could explain me if that is the case and if not why there is a huge diference. TIA Alexandre Benson Smith THOR Sof

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Alexandre Benson Smith
Em 3/3/2016 04:04, Dmitry Yemanov escreveu: > 03.03.2016 09:48, Dmitry Yemanov wrote: >>> Blobs could be moved into separate tablespace. It could make backup of >>> "data" tablespace faster and smaller. We can even think about "offline" >>> tablespace. >> Really good idea. Maybe more important for

[Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-22 Thread Alexandre Benson Smith
Hi ! On previous versions of FB (2.1 and earlier) one could not change the column datatype if it has any dependencies (for example used on a view), you need to drop all the views and after that change the column datatype and recreate everything. Fortunatelly, on FB 2.5 we could change the data

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Alexandre Benson Smith
Em 23/11/2016 08:10, Adriano dos Santos Fernandes escreveu: > On 23/11/2016 06:15, Roman Simakov wrote: >> 2016-11-23 2:26 GMT+03:00 Leyne, Sean : >>> I can't imagine how the engine could manage to keep the schema/object cache >>> and transaction context in sync or, in the absence of that, to 'bro

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Alexandre Benson Smith
Em 23/11/2016 11:08, Adriano dos Santos Fernandes escreveu: > On 23/11/2016 10:56, Alexandre Benson Smith wrote: >> create view v as select a from t; > When you use the base field directly, the view field uses the same domain. > > When you create an expression based on this field

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Alexandre Benson Smith
Em 23/11/2016 11:37, Adriano dos Santos Fernandes escreveu: > > And in my opinion problem of metadata changes and > unreliable/unpredictable behavior with concurrent sessions precedes this > one, otherwise deeper recompilation will be a big problem. Perhaps I missed your point. The case I provide

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Alexandre Benson Smith
Em 23/11/2016 12:37, Dimitry Sibiryakov escreveu: > 23.11.2016 14:54, Adriano dos Santos Fernandes wrote: >> But that (DDL changes with concurrent sessions) is unreliable. >> >> And if you change a single view that recompiles 100 views, you multiple >> the unreliability by 100 in the production env

Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-23 Thread Alexandre Benson Smith
Em 23/11/2016 11:54, Adriano dos Santos Fernandes escreveu: > On 23/11/2016 11:50, Alexandre Benson Smith wrote: >> Em 23/11/2016 11:37, Adriano dos Santos Fernandes escreveu: >>> And in my opinion problem of metadata changes and >>> unreliable/unpredictable behavi