Hi, it looks like this one was missed
after upgrading from 2.1.4 2.1.5.0-2 to I had to manually do this:
ln -s /usr/lib/firebird/lib/libfbclient.so.2.1.5 /usr/lib/libgds.so
rpm -qa | grep firebird*
firebird-classic-2.1.5.18496.0-2.el5
firebird-libfbclient-2.1.5.18496.0-2.el5
firebird-libfbembed-
>Thanks! I will most likely go with the reference table(s) option, but I
>will test both.
One alternative that I don't think have been mentioned, Cornie, is EXECUTE
BLOCK, which is simpler than a recursive CTE without requiring any extra table:
execute block returns (yearno integer, dayno integ
On Mon, 29 Oct 2012 09:40:35 +, Nick Upson wrote:
> Hi, it looks like this one was missed
>
> after upgrading from 2.1.4 2.1.5.0-2 to I had to manually do this:
>
> ln -s /usr/lib/firebird/lib/libfbclient.so.2.1.5 /usr/lib/libgds.so
To be honest, I think that is not a bug. Applications that
>
> Just to be sure: you did remove the comment symbol (#) before the config
> option and restart the server after changing it? The default Firebird
> config only has commented out config options, so it uses defaults.
>
> Mark
>
Yes Mark:) I Appreciate your concern tho :)
Hello,
Is there any way to find documentation of specific new features in
Firebird 3, so I could test, and even write blog posts on it (to
"tech" others about the features) ?
Thanks,
Ido
I need to change the scale of numeric domain from (15,4) to (15,8).
I cannot use the ALTER command, since FB doesn't allow such change.
BUT I'm 100% sure that all the existing data would perfectly fit in
(15,8) so, the question is: In this case, is it safe to make the
change direct in the system t
Hi,
The links on the official firebird web page for the Firebird 2.5.2 RC1
Windows x64 are down (http://www.firebirdsql.org/en/firebird-2-5-2-rc1/).
Thanks.
Jaume
[Non-text portions of this message have been removed]
On Mon, 29 Oct 2012 13:32:16 -0200, "Carlos H. Cantu"
wrote:
> I need to change the scale of numeric domain from (15,4) to (15,8).
>
> I cannot use the ALTER command, since FB doesn't allow such change.
> BUT I'm 100% sure that all the existing data would perfectly fit in
> (15,8) so, the questio
MR> No, a direct system table update like that would rescale all your existing
MR> numbers. Eg from (15,4) to (15,8) a value 54321.1234 would become
MR> 5.43211234
Not really. You can test by yourself... seems that stored values are
associated with a record in RDB$FORMATS that describes the origin
Hello
I Recently buied a new server with 48 Gb of memory
Currently my system only use 15 Gb of memory
I want an opinion with values i can change on firebird.conf to use more memory
an chage my performance
tanks a lot
On Mon, Oct 29, 2012 at 12:20 PM, Mark Rotteveel wrote:
> > BUT I'm 100% sure that all the existing data would perfectly fit in
> > (15,8) so, the question is: In this case, is it safe to make the
> > change direct in the system table?
> >
> > update RDB$FIELDS set
> > RDB$FIELD_SCALE = -8
> > wh
> I Recently buied a new server with 48 Gb of memory
>
> Currently my system only use 15 Gb of memory
>
> I want an opinion with values i can change on firebird.conf to use more
> memory an chage my performance
Increasing firebird memory is not necessarily required to improve performance.
Bu
On 29-10-2012 17:48, Carlos H. Cantu wrote:
> MR> No, a direct system table update like that would rescale all your existing
> MR> numbers. Eg from (15,4) to (15,8) a value 54321.1234 would become
> MR> 5.43211234
>
> Not really. You can test by yourself... seems that stored values are
> associated
At 05:02 AM 30/10/2012, Jaume Llunell Gómez wrote:
>Hi,
>
>The links on the official firebird web page for the Firebird 2.5.2 RC1
>Windows x64 are down (http://www.firebirdsql.org/en/firebird-2-5-2-rc1/).
Actually, the files are gone. We are in the process of doing the final release
of v.2.5.2,
--- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote:
>
>
>
> > I Recently buied a new server with 48 Gb of memory
> >
> > Currently my system only use 15 Gb of memory
> >
> > I want an opinion with values i can change on firebird.conf to use more
> > memory an chage my performance
>
Performance is not only memory, is a combination of network speed, hard
drive speed, memory size and speed and finally processor(s) speed.
You do not need to do that. Maybe if you do not know exactly what are you
doing you can get worst performance.
[Non-text portions of this message have been
How many simultaneous users?
What database size?
How complex is metadata?
Hi all,
I have been looking into my Firebird.log on my Windows 7 64bit running
64bit Firebird 2.5.2.26536 and I can see very often:
DEVELOP (Client)Mon Oct 29 20:56:59 2012
"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated
abnormally (4294967295)
What could b
Greetings All,
The SQL that follows pulls these results: (These results are missing 5
records from the second select of the union)
FEE_CODEAMT_EARNED_AGENCYSHOW_IN_PMT_DIST_PLANFEE_CATEGORY
CCO27610
SVC1.1710
SVC3010
This is the SQL statement:
Em 29/10/2012 18:39, SoftTech escreveu:
> Greetings All,
>
> The SQL that follows pulls these results: (These results are missing 5
> records from the second select of the union)
> FEE_CODEAMT_EARNED_AGENCYSHOW_IN_PMT_DIST_PLANFEE_CATEGORY
> CCO27610
> SVC1.1710
>
> DEVELOP (Client) Mon Oct 29 20:56:59 2012
> "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated
> abnormally (4294967295)
>
> What could be a reason or solution?
>
>
Do You use udf?
If you usually have this error, configure Windows to create a crash dump and
open a tick
SoftTech wrote:
<<
The SQL that follows pulls these results: (These results are missing 5
records from the second select of the union)
FEE_CODE AMT_EARNED_AGENCY SHOW_IN_PMT_DIST_PLAN FEE_CATEGORY
CCO2 76 1 0
SVC 1.17 1 0
SVC 30 1 0
... ...
>>
From Helen's Firebird book:
If duplicate rows are
On Mon, Oct 29, 2012 at 5:06 PM, Aage Johansen wrote:
> SoftTech wrote:
> <<
> The SQL that follows pulls these results: (These results are missing 5
> records from the second select of the union)
> FEE_CODE AMT_EARNED_AGENCY SHOW_IN_PMT_DIST_PLAN FEE_CATEGORY
> CCO2 76 1 0
> SVC 1.17 1 0
> SVC 3
Hello,
I have table with an indexed field (Firebird 2.1/2.5). When I use the query:
select * from mytable where myfield like 'test'
the plan uses the index on myfield and the query returns quickly.
When I use the query:
select * from mytable where myfield like :myparameter
and define myparame
From: Fabiano
To: firebird-support@yahoogroups.com
Sent: Monday, October 29, 2012 12:52 PM
Subject: RES: [firebird-support] Re: firebird.conf improve for lot of memory
Performance is not only memory, is a combination of network speed, hard
drive s
Em 29/10/2012 20:02, roydamman escreveu:
> Hello,
>
> I have table with an indexed field (Firebird 2.1/2.5). When I use the query:
>
> select * from mytable where myfield like 'test'
>
> the plan uses the index on myfield and the query returns quickly.
>
> When I use the query:
>
> select * from my
> > When I use the query:
> >
> > select * from mytable where myfield like :myparameter
> >
> > and define myparameter = 'test'
> >
> > the plan doesn't use the index (natural) and my query returns slowly.
> >
>
>
> Once it's a parameter, the parameter could hold any value like:
> 'ABC'
> 'ABC%
At 11:02 AM 30/10/2012, roydamman wrote:
>Hello,
>
>I have table with an indexed field (Firebird 2.1/2.5). When I use the query:
>
>select * from mytable where myfield like 'test'
>
>the plan uses the index on myfield and the query returns quickly.
>
>When I use the query:
>
>select * from mytable
Hi all,
I have a table, let say Tbl1, which structure something like this
id_cst int, id_gd int, qty int.
I want to select from that table, all records that has sum(qty) > 0 group by
id_cst and id_gd.
I have 2 options to do that :
1) create a view with a ddl like this :
create view tmp (id_
Sugi,
> I have a table, let say Tbl1, which structure something like this id_cst int,
> id_gd int, qty int.
>
> I want to select from that table, all records that has sum(qty) > 0 group by
> id_cst and id_gd.
>
> I have 2 options to do that :
> 1) create a view with a ddl like this :
>create
30 matches
Mail list logo