Re: [firebird-support] Question about few Firebird details
Hi, thanks you and others for correction now “44” i am near to understand. 45. i must test – but how look sort for your sample? ORDER BY T1.iSort and difference is because of existence of big varchar - BIGSTARTING ? If yes then something must be wrong – this sould only sort pointers and inrelevant data should not affect speed. But i do not know how this work internally – did you compare this with others RDBMS? regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Monday, May 23, 2016 9:32 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Question about few Firebird details Hi Karol, 44. This option turn off individual savepoints. Our tests proof that gives slight increase in case of massive inserts or updates. Use it with caution, since the rollback will be forced (through TIP), so if you insert less than 50k records, there could be difference with and without NO_AUTO_UNDO - Firebird will be not able to transform rollback into commit with savepoints. If you insert more than 50k records (actually 50-60k, it depends on memory, not exact ##, if I remember correctly), rollback will be done through TIP anyway. 45. Try it with table like CREATE TABLE T1(i1 integer not null primary key, iSort integer, BIGSTARTING VarchaR(2000)); insert there 10 mln records and do 2 queries as in the example. It will take 10 mins, and and you'll see the difference by yourself. Regards, Alexey Kovyazin IBSurgeon Hi, https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ i have few questions: 44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not understand what really do this option.. 30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY - SELECT T.FIELD_KEY, T.FIELD1, T.FIELD2, ... T.FIELD_N FROM (SELECT FIELD_KEY FROM T ORDER BY FIELD2) T2 JOIN T ON T.FIELD_KEY = T2.FIELD_KEYwhy this can be faster then? SELECT FIELD_KEY, FIELD1, FIELD2, ... FIELD_N FROM T ORDER BY FIELD2Firebird sort whole resultset of "sorted key - Field2" or do different work? I see in FB3 plan sort width and it looks like not true but? regards, Karol Bieniaszewski
[firebird-support] Is Firebird 3 ready for Production?
Hi All We have a multi-user, multi-company, cloud based system running with Firebird 2.54 as the main database, with about 100 concurrent connections. We are considering migrating to FB 3.0 to take advantaje of the SMP architecture, we have a 32 core / processors server, so we are hopping to see an increased performance. We also have the need to set up online replication. Would anyone be able to advise if it it too soon to jump into FB 3.0 for production? And if the performance increase would be enough to make the upgrade worth considering 3.0 has not been around for long yet, and may be "taking too much risk" to move into it so soon? And regarding the replication, any advise on what product may be the right choice? Cheers Fabian
[firebird-support] Re: ODP: FB 3 issues with String from FB 2.54
liviuslivius liviuslivius poczta.onet.pl [firebird-support] yahoogroups.com> writes: > > > > > > > hi, > > will be good to know which charsets did you tried. utf8, none, octets... > > but remember to connet to db also with this charset settings > > regards, > Karol Bieniaszewski > Oryginalna wiadomość Od: "fabianch itbizolutions.com.au [firebird-support]" yahoogroups.com> Data: 23.05.2016 03:45 (GMT+01:00) Do: firebird- support yahoogroups.com Temat: [firebird-support] FB 3 issues with String from FB 2.54 > > > > > > > > Hi All > > I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and after hitting a string related error for some time i have got to the point where I do understand the issue, but I don't know how to solve it. The issue is pretty simple, the FB 2.54 DB contains a few characters that are not allowed into the FB 3 database, one example of a character causing an error during the restore was "Mcgarrity’s" (note the ’) as it appears to be outside the scope of the FB3 string domain, I have trying creating a new FB3 DB with many different charsets but none works. The other string causing issues is for example "΢ÈíÑźÚ", I have many records with this type of strings because the DB contains raw emails received by the system, stored into Varchars, and apparently some emails contain very weird characters, all were handled by FB2.54 but FB3 rejects the records. I have been able to isolate all recrods with issues using IBExpert's table data comparer function, as it created a script with all recrods from all tables from FB2.54 and when running the script against FB3.0 it singles out all the offending records. > > Can anyone advise what options I have available to force FB3.0 to accept any stuff into string fields? > > > Thanks in advanced > > > > > > > > > > > > > > > > Hi Karol After playing with the problem for a while I noticed the definition of the field was Varchar (8192) charset ASCII collate ASCII, so that was probably causing the problem. I changed the domain settings to be Charset NONE, Collate NONE, and that fixed the issue! Cheers, Fabian
Re: [firebird-support] Re: Question about few Firebird details
Hi, Yes, sure, my mistake - I should not answer questions so late and need to sleep more :) Regards, Alexey 23.05.2016 22:32, Alexey Kovyazin wrote: > > 44. This option turn off individual savepoints. Individual savepoints are never turned off. This option disables the root (transaction-level) savepoint used to transform a rollback into a commit (by undoing all the transaction changes). Dmitry
[firebird-support] Re: Translating Firebird.MSG - pt_BR
23.05.2016 17:22, 'Heron Vieira' wrote: > > I'd like to translate firebird.msg, but I think I hit a wall with the > size of the messages. > > So far I translated some messages by editing the file in a HEX editor, > but I think the correct way would be modifying the source code, but I've > no idea where to start. > > I searched the files on github and found nothing about firebird.msg. > > So I need some advice on how it works and what should I do. Look here: https://github.com/FirebirdSQL/firebird/tree/master/src/msgs messages2.sql is the file you need to translate. transmsgs.de_DE2.sql and transmsgs.fr_FR2.sql are older (now outdated) translation attempts. Dmitry
[firebird-support] Re: Question about few Firebird details
23.05.2016 22:32, Alexey Kovyazin wrote: > > 44. This option turn off individual savepoints. Individual savepoints are never turned off. This option disables the root (transaction-level) savepoint used to transform a rollback into a commit (by undoing all the transaction changes). Dmitry