Re: [Firebird-devel] Latest OLTP results DB size resolved

2019-02-17 Thread Gabor Boros
2019. 02. 14. 21:07 keltezéssel, Karol Bieniaszewski írta: >> Can you execute same SS (2.5 vs 3.0) tests with 5 ISQL sessions? I do not know what purpose for only 5 ISQL but here you are. Thank you very much! Gabor Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Values for isc_dpb_session_time_zone

2019-02-17 Thread Adriano dos Santos Fernandes
On 17/02/2019 08:33, Mark Rotteveel wrote: > It would be helpful if Firebird already had an explicit default value > (as then I can just document that, and I don't need to have logic to > treat a Jaybird specific value as 'don't set'). I don't think it should. Just don't add it to DPB. Adriano

Re: [Firebird-devel] Values for isc_dpb_session_time_zone

2019-02-17 Thread Adriano dos Santos Fernandes
On 17/02/2019 08:08, Mark Rotteveel wrote: > Does isc_dpb_session_time_zone have an explicit default value? What I > mean is, can you set a value (maybe local?) that behaves as if the value > is not set (and thus uses the DefaultTimeZone config or system time zone)? > No. > In addition, is

[Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-17 Thread Adriano dos Santos Fernandes
Open two connections C1 and C2. C2: select current_transaction from rdb$database; -- let's call the result T2 C2: commit; C1: select rdb$get_transaction_cn(T2) from rdb$database; In Super C1 returns the commit number. In Classic it returns NULL. Adriano Firebird-Devel mailing list, web

[Firebird-devel] Interesting OLTP results on RAM Disk and question about

2019-02-17 Thread Karol Bieniaszewski
Hi. I resend and shortened this email because previous emails are gone on the list ☹ I set first only 2048 buffers as i supposed buffers does not matter on RAM DISK because read from file is really read from RAM. But to my surprise (maybe not so big surprise) the results are >3 times slower

[Firebird-devel] Interesting OLTP results on RAM Disk - question about results

2019-02-17 Thread Karol Bieniaszewski
I set first only 2048 buffers as i supposed buffers does not matter on RAM DISK because read from file is really read from RAM. But to my surprise (maybe not so big surprise) the results are as >3 times slower. Is this overhead becouse of using Windows file read api compared to direct read from

[Firebird-devel] test

2019-02-17 Thread liviuslivius
test message, because i have send two emails 16.02.2019 23:12 and 16.02.2019 23:27 but i still do see them on the group   regards, Karol Bieniaszewski  Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6002) system procedure named "TRANSITIONS" without "RDB$" prefix

2019-02-17 Thread Segey Khalyutin (JIRA)
system procedure named "TRANSITIONS" without "RDB$" prefix -- Key: CORE-6002 URL: http://tracker.firebirdsql.org/browse/CORE-6002 Project: Firebird Core Issue Type: Bug

[Firebird-devel] [FB-Tracker] Created: (CORE-6001) slow select on RDB$PROCEDURE_PARAMETERS and RDB$FUNCTION_ARGUMENTS (index`s created on incorrect fields)

2019-02-17 Thread Segey Khalyutin (JIRA)
slow select on RDB$PROCEDURE_PARAMETERS and RDB$FUNCTION_ARGUMENTS (index`s created on incorrect fields) Key: CORE-6001 URL:

Re: [Firebird-devel] Values for isc_dpb_session_time_zone

2019-02-17 Thread Mark Rotteveel
On 17-2-2019 12:08, Mark Rotteveel wrote: Does isc_dpb_session_time_zone have an explicit default value? What I mean is, can you set a value (maybe local?) that behaves as if the value is not set (and thus uses the DefaultTimeZone config or system time zone)? In addition, is

[Firebird-devel] Values for isc_dpb_session_time_zone

2019-02-17 Thread Mark Rotteveel
Does isc_dpb_session_time_zone have an explicit default value? What I mean is, can you set a value (maybe local?) that behaves as if the value is not set (and thus uses the DefaultTimeZone config or system time zone)? In addition, is isc_dpb_session_time_zone case insensitive (ie will