Step 1 is better if you are going from dialect 1 to 3, mostly due to
the difference in the numerics internal storage.
I see no problem with any of the approaches.
I would add that, imho, step 4 in process 2 is not really necessary,
unless you want to reset the metadata versions count of the
You didn't say what version of Firebird you are using. If it is not
3.x, you can expect very bad performance transferring data over WAN.
FB 3 implemented changes in the wire protocol making things much
faster in high latency networks. The only remaining "problem" is if
you need to transfer blobs
Is this link permanent? if so, and if you agree, I can publish it at
firebirdnews.org
[]s
Carlos
www.firebirdnews.org - www.FireBase.com.br
NSGntefs> 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
>> Hi!
>>
>> If you have a compiled version with t
Hi!
If you have a compiled version with the fix, I think a lot of people
would enjoy if you can share the executable ;-)
Carlos
www.firebirdnews.org - www.FireBase.com.br
DSsicfs> 02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support] wrote:
>> IB Data
IB DataPump from Clevercomponents has problems with FB 3, but now it
is open source. It is made in Delphi. If someone interested and with
some free time can fix the problem and even update the application:
https://github.com/CleverComponents/Interbase-DataPump/
[]s
Carlos
Migration Guide do FB 3
NSGntefs> Personally, I use news://news.gname.org to read and possibly respond
to
NSGntefs> the mailing of different groups of Firebird.
NSGntefs> This allows me to search for a topic on the 18713 current posts of
this
NSGntefs> group
Afaik, gmane is mostly abandoned. Sooner or later it seems
KSKSRScfs> Thanks!
KSKSRScfs> Kevin
KSKSRScfs>
>> On Oct 2, 2019, at 10:24 AM, 'Carlos H. Cantu' lis...@warmboot.com.br
>> [firebird-support] wrote:
>>
>> KSKSRScfs> My question:
>> KSKSRScfs> Now that my 1.56 metadata script works w/out error w
KSKSRScfs> My question:
KSKSRScfs> Now that my 1.56 metadata script works w/out error with
KSKSRScfs> the 3.0 database, can I simply backup the 1.56 database and restore
under FB 3?
In theory, yes. But note that the BLR of existing objects (procedures,
etc) are not recompiled when you do a
RAMMap 1.51 works fine with Windows 10.
Carlos
Migration Guide to Firebird 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/
tycfs> Hi guys,
tycfs> I compared firebird 3 SS performance in windows 10 pro 64 vs
tycfs> Linux mint 19.1 cinnamon 64 bit.
tycfs> Both OS use the same
MRmlnfs> Truncate table (CORE-2479) isn't implemented yet, so it is unsure this
MRmlnfs> will land in Firebird 4.
MRmlnfs> Mark
Btw, truncate was predicted for Firebird 3, but something seems to be
delaying its implementation :-(
I hope it will be available for FB 4, and even better if it can
Script is just a bunch of SQL statements executed in sequence. An
insert script will never be faster than using prepared parametrized
statements, since with scripts, Firebird will have to prepare/execute
statements one by one.
For specific cases, user may try to put the "inserts" inside an
LCllcufs> On 07/09/17 11:04, Lester Caine les...@lsces.co.uk [firebird-support]
wrote:
LCllcufs> Nobody using Firebird for web site content?
The whole www.firebase.com.br is stored in a Firebird database. The
site is coded in PHP. I'm not using any CMS. The only thing that I'm
still missing is
RFrfmcbfs> Those are for 2.5 arent them?
RFrfmcbfs> The only ones I found there are at
RFrfmcbfs> https://ib-aid.com/br/optimized-firebird-configuration/
There is conf for FB 3 too, scroll down the page.
[]s
Carlos
Migration Guide to FB 3 -
There is optimized configuration files in the IBSurgeon site. You can
use it as a base, and fine tune as you need.
Carlos
Migration Guide to FB 3 -
http://www.firebirdnews.org/migration-guide-to-firebird-3/
RFrfmcbfs> Hello
RFrfmcbfs> We have recently installed FB 3 on SuperServer mode.
Hi!
ReadCommited + ReadOnly transactions do not block garbage collection,
since they are started in pre-commited mode.
Carlos
Migration Guide to Firebird 3
http://www.firebirdnews.org/migration-guide-to-firebird-3/
ACacacfs> Hello,
ACacacfs> Supposing a connection only needs to read from
I go with Sean.
Btw, this is already in the tracker:
http://tracker.firebirdsql.org/browse/CORE-1738
Vote on it!
Carlos
www.firebirdnews.org - www.FireBase.com.br
>> > Any suggestions on my DB design and query to display the values in matrix
>> (pivot) format?
>>
>>Simple client-side
ficafs> 2) Use the new FB 3 encrytion, we do not have any idea how to, is there
any
ficafs> document we can read to start testing?
There is an example of a crypt plugin in every FB 3 installation. You
can use it as a base to create your own encryption plugin. Or you can
buy IBSurgeon's
Hello!
I would like to inform that my "Migration Guide to Firebird 3" eBook is
now also available in Printed format.
All information can be found here:
www.firebirdnews.org/migration-guide-to-firebird-3/
Any questions, please contact me privately (do not post to this list).
[]s
Carlos
Awesome! Congratulations to all the people who made this possible!
Btw, I will take the opportunity to announce that my "Migration Guide
to Firebird 3" eBook is being sold at
http://www.firebirdnews.org/migration-guide-to-firebird-3/
[]s
Carlos H. Cantu
www.firebirdnews.org - www.FireBase.com.br
LSSBcfs> It has not!
LSSBcfs> RC releases should not be used for production purposes.
Just a note: FB 3 RC2 will become the final release, unless someone
finds a critical bug or regression that would require another RC.
[]s
Carlos
www.firebirdnews.org - www.FireBase.com.br
In Firebird 3, compression is OFF by default. You can enable it
in firebird.conf (parameter WireCompression = true).
Carlos
www.firebirdnews.org - www.FireBase.com.br
K> Thank you Mark.
>> 3. Compression
K> Is compression default on or do I have to edit a config parameter?
K> Regards
K>
Please answer the survey at
https://esurv.org/?u=fb3installer
Survey will be closed in 20-Nov-2015.
PS: Please don't answer in this discussion list. There is comment
field in the survey, if you want to say something.
[]s
Carlos
Firebird Performance in Detail -
For those interested to know how FB 3 protocol was improved to work
better over internet:
http://www.firebirdnews.org/firebird-3-protocol-benchmark/
Spoiler: Now you should think twice before saying that MySQL is faster ;-)
[]s
Carlos
Firebird Performance in Detail -
Take a look at this:
https://www.youtube.com/watch?v=ibZKgmHz9_4feature=youtu.be
[]s
Carlos H. Cantu
www.FireBase.com.br - www.firebirdnews.org
www.warmboot.com.br - blog.firebase.com.br
SCMSmsscdf …many thanks; that’s what I was looking for! So there’s a
SCMSmsscdf great many work under way,
I would suggest you to get the Firebird Book II, from Helen Borrie, so
far the most complete doc about Firebird in English. You can buy it
at ibphoenix.com, Amazon, etc.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
Maybe storing it into a CHAR(22) using OCTECTS charset?
Helen's book describes octets as:
OCTETS | BINARY
Bytes which will not be interpreted as characters. Useful for storing
binary data, GUID strings, hexidecimal numbers and for correcting
string data that is causing transliteration errors.
LSSBcfs Your problem is the infamous Windows 64bit File Cache causes excessive
Page File usage.
Btw, afaik, 2.5.3 should not have this problem with the Windows cache.
[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
SETsetknfs One thing to notice, Olaf, is that where cast(b.ts as
SETsetknfs date) will never use an index (if you have an index on
SETsetknfs TS).
Just a note: afair, it can use an index if you have the index key
defined also as cast(b.ts as date).
Carlos
Firebird Performance in Detail -
LSSBcfs Our application uses BLOB fairly extensively and can report
LSSBcfs that the GBAK disk write rate increases very significantly
LSSBcfs when tables with Blobs are being backed-up, orders of
LSSBcfs magnitude faster than tables with small rows (YMMV), so this
LSSBcfs suggests that SEGMENT
DYdusnfs IIRC, unicode derived case/accent insensitive collations use six bytes
DYdusnfs per character encoding. This gives us 2010 bytes which is pretty near
DYdusnfs the 1/4 page size. Given that some overhead should be taken into
DYdusnfs account, the key length may in fact overflow the
I never said it would cover all possibilities. I just said that
instead of guessing or stay only with the theory, a real test
could give more trustful results ;)
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
EHehdfs Am
DYdusnfs It's not about when your DDL is applied but about the cached procedure
DYdusnfs BLR that is used by others. The changed (new) procedure BLR will be
used
DYdusnfs by newly compiled statements immediately after your DDL has been
DYdusnfs executed. However, all already compiled statements
To avoid such error, try to change the DDL transaction parameter to
WAIT instead of NO WAIT.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
HEhmcfs Hello.
HEhmcfs IBExpert shows the message:
HEhmcfs lock conflict on no
Usually, if you turn FW = ON on Linux, and your filesystem has barrier
enabled, it will affect performance of batch updates really badly.
You would either accept the performance degradation, or disable one of
them (FW or barrier).
Carlos
Firebird Performance in Detail -
LSSBcfs While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs A connection can hold an object in use for an indeterminant period of
time.
Dmitry said to me sometime ago that procedures changes will be
executed immediately and not get held. I tested and
Are the indexes statistics up to date?
Also, post the query, query plan, and indexes stats.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
ACacacfs Hello,
ACacacfs In a select statement there are two tables joined
91 matches
Mail list logo
