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 objec
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 (i
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
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:
>&g
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 th
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/o
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 restor
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 databas
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 be
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
execute
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 t
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 -
http://www.firebirdnews.org/migration-guide-to-firebird
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.
RFrfmc
If you are speaking about Change Views feature, I understand its main
purpose is to help mobile applications to update local copies of
(changed) data easily.
[]s
Carlos
Migration Guide to Firebird 3 -
http://www.firebirdnews.org/migration-guide-to-firebird-3/
http://www.firebirdnews.org/m
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 a
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 cod
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 encryptio
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
www.fireb
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> Martin
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 - http://videos.firebirddevelopersda
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 - http://videos.firebirddevelo
Take a look at this:
https://www.youtube.com/watch?v=ibZKgmHz9_4&feature=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
bb
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. Ali
LvAlnczfs> Personally I won’t connect directly over a high latency
LvAlnczfs> connection. You risk inconsistent updates and corruption.
You are wrong. You cannot corrupted database because you are using a
connection over a high latency network. The same applies for
inconsistent updates (that's why
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 - h
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 SEGMEN
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 li
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
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 statemen
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 an
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 - http://videos.firebirddeve
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
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 joine
1 - 100 of 103 matches
Mail list logo