Hi!
I have different Firebird instances/databases, one is running on Windows,
another on Linux (the servers have different RAM amount as well). The execution
of the same SQL code results in almost the same indexed reads, non-indexed
reads statistics, but the numbers of read and fetch
Hi Jonathan,
Most likely you have different firebird.conf.
Align them and check again.
Regards,
Alexey Kovyazin
Hi!
I have different Firebird instances/databases, one is running on
Windows, another on Linux (the servers have different RAM amount as
well). The execution of the same SQL code
I managed to find the exact cause (in terms of SQL) of this difference.
I have simple update statement like
update contract set
total=total
where contract_number=5;
When I call this statement 2 times (in the same transaction) on the Windows
server, then the number of reads for the second
Of course, I checked the triggers of this table. There are not any dependencies
or futher updates in them. The size of the table is very modest - less several
thousands of records. It is heavily used - both in selects and updates.
The strangest part of the store is this - such unexpected reads
On 11 Jun 2014 07:50:26 -0700, jonatan.laurit...@yahoo.dk
[firebird-support] firebird-support@yahoogroups.com wrote:
It is really strange behavior. It is hard to imagine any kind of
configuration that could result in such behaviour.
It could be explained if one is Classic Server and the other
Hello Good Morning,
I’m with one error that I cannot found any help on the internet, and I Hope I
could get any help...
I’m migrating a database to the cloud, but, I’m getting the “conversion error
from string #Timestamp#” problem when I’m making the insert on the cloud
database.
The date
Hi Augusto,
if the insert-string contains timestamp information in the form you
specified, no error should occur.
Are you sure, that the data does not contain the string 'Timestamp' (as
the error message indicates)?
Are you able to log your datastream during pump to the cloud?
Are you able to
Hello Good Morning,
I’m with one error that I cannot found any help on the internet, and I Hope I
could get any help...
I’m migrating a database to the cloud, but, I’m getting the “conversion error
from string #Timestamp#” problem when I’m making the insert on the cloud
database.
The date is
