Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Thomas Steinmaurer
Vlad, Currently, I re-run the test case mentioned in my initial email. Still running. I then will also run a test case where inserting GUIDs into a non-indexed column will happen. Perhaps adjusting the index tree for GUIDs is slow. Inserting into a table with a GUID column as primary key

Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, SET TRANSACTION

2011-04-04 Thread Kovalenko Dmitry
Fixed. Thanks. Please, append in source code the comment for this fix. Because in each new version (begin from 2.0) this feature is broken :) Regards, Dmitry Kovalenko. -- Create and publish websites with WebMatrix

Re: [Firebird-devel] FB3. CREATE OR ALTER TRIGGER

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 13:37, Kovalenko Dmitry wrote: Hi SQL Script set transaction; create table TEST_36187 (ID INTEGER); create trigger BI_TEST_36187 for TEST_36187 before insert as declare variable x integer; begin select count(*) from TEST_36187 into :x; end; CREATE OR ALTER trigger

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Frank Schlottmann-Goedde
On 04.04.2011 12:45, Thomas Steinmaurer wrote: Vlad, First, try to insert 1mln *random* INTs, i.e. not in sequential order. Else you compare apples (sequential numbers) with oranges (random numbers) :) Good one. This makes a difference. Will put that in a list for a possible pro/con

[Firebird-devel] [FB-Tracker] Created: (CORE-3429) Part of gbak messages from services is lost before error message

2011-04-04 Thread Yurij (JIRA)
Part of gbak messages from services is lost before error message - Key: CORE-3429 URL: http://tracker.firebirdsql.org/browse/CORE-3429 Project: Firebird Core Issue Type: Bug