On 13-03-2015 22:44, Hajime Nakagami wrote:
Hi,
I made patch to add some functions about standard division.
https://github.com/FirebirdSQL/core/pull/2
Can someone merge this patch ?
Commented in https://github.com/FirebirdSQL/core/pull/2
Adriano
Hello,
It looks like i might have run into a bug in Firebird version 2.5.3
(also 2.5.2).
I have databases with ON CONNECT trigger that load some context values
from a table. However, some times the context values appear to have not
been loaded (or loaded and lost?). I am absolutely sure the
GFIX fails to output in my app but outputs nicely in CMD screen
---
Key: CORE-4711
URL: http://tracker.firebirdsql.org/browse/CORE-4711
Project: Firebird Core
Issue Type: Bug
Dmitry Yemanov firebi...@yandex.ru писал(а) в своём письме Mon, 16 Mar
2015 11:53:44 +0300:
16.03.2015 10:58, liviuslivius wrote:
snapshot of Firebird3 not conatain employee.fdb and also full script
for it
IIRC, it was temporarily disabled one day due to Windows build issues
and
On 16-03-2015 04:58, liviuslivius wrote:
Hi,
snapshot of Firebird3 not conatain employee.fdb and also full script for it
But if i restore it from FB2.5 then
README.window_functions.txt
Examples in this file are just abstract. Nothing to do with the
employee.fdb database.
Hi Jim,
I made some research about storage compresion and I found this project:
https://code.google.com/p/lz4/
My idea is to use this only if encoded size of record will be more than
aprox 4Kb.
Do you have any note, why it can be bad idea?
Thanks Slavek
PS: I was made some changes in
The main blocker for switching to firebird as base backend is
firebird data format endianess.
The main remaining issue is that the firebird data format embedded in the
.odb file is endianess-dependent. The idea is to switch to Firebird's
archive format that is not.
16.03.2015 17:17, marius adrian popa wrote:
The main blocker for switching to firebird as base backend is
firebird data format endianess.
Using Firebird in office siute was a bad idea from the beginning. No matter
that
Firebird Embedded exists, it still is a client-server thing in the
I'd like to see some numbers computed from an actual (real) Firebird
database before it is considered.
But why records only over 4k? And what commonality do you expect to find
on large records?
On Monday, March 16, 2015, Slavomir Skopalik skopa...@elektlabs.cz wrote:
Hi Jim,
I made some
On 03/16/15 19:42, James Starkey wrote:
I'd like to see some numbers computed from an actual (real) Firebird
database before it is considered.
Test with tpcc.fdb using lz4 command line (not most realistic sample in
the world, but hopefully more or less OK).
DB file is 211864K, after
How you are declaring it in the record?
You should use ISC_QUAD.
Adriano
I use Int64 it is equivalent to ISC_QUAD
but I see what hapened
Whe should decide about buffer alignment
I can use packed record instead of record then data are as is
But what is your buffer alignment when you fill data in
Hi Adriano,
I'm using Firebird for a long time.
I decided that I could do something more for the Firebird community.
I started working on support for all types supported by the Firebird in your
FB Api on Delphi.
And so I now have the following types of operating correctly:
-Integer,
-Date,
On 16-03-2015 19:54, liviusliv...@poczta.onet.pl wrote:
How you are declaring it in the record?
You should use ISC_QUAD.
Adriano
I use Int64 it is equivalent to ISC_QUAD
It's really Int64. ISC_QUAD is for blobs.
but I see what hapened
Whe should decide about buffer alignment
I can
Hello again,
After further investigation, it turns out the problem is NOT with
context values getting lost but rather in the ON CONNECT database
trigger not firing when connecting. Furthermore, so far it has always
been the SECOND attachment to the db (by attachment id) after OS restart
where
On 16-03-2015 17:52, liviusliv...@poczta.onet.pl wrote:
Hi Adriano,
I'm using Firebird for a long time.
I decided that I could do something more for the Firebird community.
I started working on support for all types supported by the Firebird in your
FB Api on Delphi.
Good!
And so I
Hi,
snapshot of Firebird3 not conatain employee.fdb and also full script for it
But if i restore it from FB2.5 then
README.window_functions.txt
contain fields which not exists like:
ID there is emp_no
department there is dep_no
regards,
Karol Bieniaszewski
-Oryginalna wiadomość-
From: Slavomir Skopalik
Sent: Monday, March 16, 2015 5:28 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Recore level compresion imroovement
Hi Jim,
I made some research about storage compresion and I found this project:
Hi Jim,
I have only my DBs, that is designed for short record length (on disk).
I looking for some real examples, but is not easy to get it.
Some data from my DB (new RLE):
Primary pointer page: 384, Index root page: 385
Total formats: 1, used formats: 1
Average record length: 31.20,
Hi Karol,
in current simplified stack you have:
execution engine
record level compresion
page storage
cache
hdd
On small records, you have CPU problem, but on large records you can
simply utilize HDD.
To utilize HDD tou have to meet at least ~200MB/s on common CPU.
Target is: be able utilize
The oroblem with that technique is that lz4 get getting credit fir
compression of partially empty data and index pages and tips and space
utilization pages that have predictable repeating content.
There's really no way to estimate the effective compression other than to
code it up and try it.
invalid request BLR at offset 361 context already in use (BLR error)
Key: CORE-4710
URL: http://tracker.firebirdsql.org/browse/CORE-4710
Project: Firebird Core
Issue Type:
16.03.2015 10:58, liviuslivius wrote:
snapshot of Firebird3 not conatain employee.fdb and also full script for it
IIRC, it was temporarily disabled one day due to Windows build issues
and supposedly forgotten to be enabled back. I will check.
Dmitry
22 matches
Mail list logo