On Mon, 29 Oct 2012 09:40:35 +, Nick Upson n...@telensa.com 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.
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
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
lis...@warmboot.com.br 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)
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 original
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 m...@lawinegevaar.nlwrote:
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 =
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.
But
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 with a
--- In firebird-support@yahoogroups.com, Leyne, Sean 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 be
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
SVC
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 ticket in the
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 aagjo...@online.no 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
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
From: Fabiano fabianoas...@gmail.com
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
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 mytable
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%'
'%ABC'
the
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 where
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
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 view tmp
27 matches
Mail list logo