[Firebird-devel] Performance after CREATE DATABASE

2011-04-06 Thread Geoff Worboys
Hi All, Wasn't sure whether to start here or on the support list. Came here because it partly relates to another thread. I was trying to create a script to reproduce the problem described by Thomas in the thread: [Firebird-devel] GEN_UUID() performance? At first I had trouble seeing the problem

[Firebird-devel] RDB$SET_CONTEXT, mistake in system table for return value

2011-04-06 Thread Kovalenko Dmitry
Hi Firebird 2.5.1 IBExpert returns the next description of RDB$SET_CONTEXT DECLARE EXTERNAL FUNCTION RDB$SET_CONTEXT VARCHAR(80) CHARACTER SET NONE NULL, VARCHAR(80) CHARACTER SET NONE NULL, VARCHAR(255) CHARACTER SET NONE NULL RETURNS INTEGER CHARACTER SET NONE BY VALUE << !!! E

Re: [Firebird-devel] Connection-based cache value?

2011-04-06 Thread Thomas Steinmaurer
> using isql/fsql one can supply a CACHE argument at connect time. I > guess that's a temporary page buffers value for this particular > connection, right? > > I've tried Firebird Classic and SuperClassic (I guess it isn't supported > in SuperServer at all). The database has a page buffers value o

[Firebird-devel] [FB-Tracker] Created: (CORE-3432) Bad Optimzer PLAN depending on joined tables in the query

2011-04-06 Thread rudi feijo (JIRA)
Bad Optimzer PLAN depending on joined tables in the query - Key: CORE-3432 URL: http://tracker.firebirdsql.org/browse/CORE-3432 Project: Firebird Core Issue Type: Bug Componen

Re: [Firebird-devel] [FB3] RDB$FUNCTIONS and RDB$GET_CONTET/RDB$SET_CONTEXT

2011-04-06 Thread Dmitry Yemanov
06.04.2011 12:28, Kovalenko Dmitry wrote: > > [FB 2.5.1] "RDB$FUNCTIONS" contains the record for RDB$GET_CONTEXT, > RDB$SET_CONTEXT functions > [FB 3.0] "RDB$FUNCTIONS" (in new database) is empty > It is right? I recall the discussion about making the context functions really internal (and thus i

[Firebird-devel] [FB3] RDB$FUNCTIONS and RDB$GET_CONTET/RDB$SET_CONTEXT

2011-04-06 Thread Kovalenko Dmitry
Hi [FB 2.5.1] "RDB$FUNCTIONS" contains the record for RDB$GET_CONTEXT, RDB$SET_CONTEXT functions [FB 3.0] "RDB$FUNCTIONS" (in new database) is empty It is right? Kovalenko Dmitry.-- Xperia(TM) PLAY It's a major breakth