Re: [Firebird-devel] GEN_UUID() performance?
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 takes here ~62 minutes. Inserting into table with an non-indexed GUID column takes ~10 seconds. Shall I open a ticket with a proper test case? 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 discussion. Thanks! Thomas -- Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, SET TRANSACTION
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 Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FB3. CREATE OR ALTER TRIGGER
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 BI_TEST_36187 active after insert position 1 as declare variable x integer; begin select count(*) from TEST_36187 into :x; end; Firebird 2.5 executes these SQL without problem Firebird 3.0 returns the error for last statement: Incompatible trigger type It is right? IMO, yes. It's *CREATE OR* ALTER, and it's a DML trigger, so the table name is required. Adriano -- Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] GEN_UUID() performance?
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 discussion. And they should better be distinct :-) We did some tests while ago with our own guid-generator and we are meanwhile using guids as primary keys. They have some overhead on insert, but pay back later (especially when replicating data between many databases) I hope I can switch from our udf to built in uuids in the near future. mit freundlichen Grüßen Frank Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling -- Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3429) Part of gbak messages from services is lost before error message
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 Components: GBAK Affects Versions: 2.5.0 Environment: FB 2.5, Windows 2003SP1 Reporter: Yurij Priority: Minor When restoring invalid backup(e.g. with nulls in not null column) through services API and with -v option, part of informational log messages just before an error message is lost. With error message not containing table name, it becomes difficult to determine which table caused an error. When restoring without services API, all informational messages appears in log: with services API: gbak:restoring data for table ROUTES gbak: 8 records restored gbak:restoring index PK_ITINTAGS . here about 20 messages is lost... gbak: ERROR:validation error for column EVT_NULLBUG, value *** null *** gbak: ERROR:warning -- record could not be restored without services API: gbak:restoring index U_SEN_ID gbak:restoring index PK_EVT_ID gbak:restoring index IDX_EVT_DT gbak:restoring data for table EVENTS gbak: ERROR:validation error for column EVT_NULLBUG, value *** null *** gbak: ERROR:warning -- record could not be restored -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel