Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Leyne, Sean
> > - Asynchronous File I/O > >It is not really asynchronous as it waits for the completion of every > single IO > request. True, but it allows the storage controller to decide the best order in which to perform the operations... > Also, note, it completely disables file system

[Firebird-devel] [FB-Tracker] Created: (CORE-5552) How to collect garbage in TEMPORARY table?

2017-05-25 Thread Oleg Matveyev (JIRA)
How to collect garbage in TEMPORARY table? -- Key: CORE-5552 URL: http://tracker.firebirdsql.org/browse/CORE-5552 Project: Firebird Core Issue Type: Bug Components: Engine Affects

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Vlad Khorsun
25.05.2017 22:18, Leyne, Sean wrote: What's SUPERSERVER_V2 in the code? My review of the code (back in 2003, see attached) found the following: - Asynchronous File I/O It is not really asynchronous as it waits for the completion of every single IO request. Also, note, it completely

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Dmitry Yemanov
25.05.2017 18:53, Adriano dos Santos Fernandes wrote: What's SUPERSERVER_V2 in the code? Old attempt by Borland to implement some features that can be utilized by a properly threaded SuperServer. Will it be used some day? Will it be removed some day? We preserve it as a reference. Some

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Leyne, Sean
Forgot to attachment... > -Original Message- > From: Leyne, Sean [mailto:s...@broadviewsoftware.com] > Sent: Thursday, May 25, 2017 3:19 PM > To: For discussion among Firebird Developers de...@lists.sourceforge.net> > Subject: Re: [Firebird-devel] SUPERSERVER_V2 > > > > > What's

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Leyne, Sean
> What's SUPERSERVER_V2 in the code? My review of the code (back in 2003, see attached) found the following: - Asynchronous File I/O - PreFetch Data Pages (i.e. statement is a natural scan so read-ahead in the file...) - Defer Header Page Write (i.e. reduce the number of times that the header

[Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Adriano dos Santos Fernandes
Hi! What's SUPERSERVER_V2 in the code? Will it be used some day? Will it be removed some day? Adriano -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

[Firebird-devel] [FB-Tracker] Created: (CORE-5551) Seperation of identifers from underlying objects

2017-05-25 Thread Howard Johnson (JIRA)
Seperation of identifers from underlying objects Key: CORE-5551 URL: http://tracker.firebirdsql.org/browse/CORE-5551 Project: Firebird Core Issue Type: New Feature Environment:

Re: [Firebird-devel] Detecting a parameter is DB_KEY

2017-05-25 Thread Adriano dos Santos Fernandes
On 25/05/2017 05:13, Mark Rotteveel wrote: > How can I find out if a parameter is a DB_KEY? > > When describing "select column1 from testrowid where rdb$db_key = ?", > how can I derive from the parameter information that this is actually a > db_key? > > For selected fields like in "select

[Firebird-devel] [FB-Tracker] Created: (CORE-5550) Computed decimal field in a view has wrong RDB$FIELD_PRECISION

2017-05-25 Thread Jiri Cincura (JIRA)
Computed decimal field in a view has wrong RDB$FIELD_PRECISION -- Key: CORE-5550 URL: http://tracker.firebirdsql.org/browse/CORE-5550 Project: Firebird Core Issue Type: Bug

[Firebird-devel] Detecting a parameter is DB_KEY

2017-05-25 Thread Mark Rotteveel
How can I find out if a parameter is a DB_KEY? When describing "select column1 from testrowid where rdb$db_key = ?", how can I derive from the parameter information that this is actually a db_key? For selected fields like in "select rdb$db_key, column1 from testrowid" it is easy: just check