Stephane,
i not understand, it's write that raid 10 is recommended ! ??
The RAID levels and their relative performance trade-offs can be seen on the
following link:
http://pcguide.com/ref/hdd/perf/raid/levels/comp-c.html
For a production server, RAID 0 is NEVER EVER EVER recommended. It had
Tom,
Can anyone explain why FB uses all 3 in the OR query yet only 2 in the AND
query (See definitions below)?
select * from target
where
upper(company) starting with 'A' and
upper(firstname) starting with 'B' and
upper(lastname) starting with 'C'
PLAN (TARGET INDEX
Dmitry,
Next, your database have NO RESERVE flag turned on.
This is BAD, since you speaking about updates.
Good catch! I completely missed that!
I agree, this is VERY BAD!
Sean
i think that Ram disk with strong power supply can be a good choice.
ONLY DO THAT IF THE DATABASE IS 100% READ-ONLY!
Or if you don't care about losing any updates which have been applied.
A soon as power faillure is detected the software stop the firebird and copy
the entire ram disk to
Roberto,
The question is that, according to the german culture, there is over and over
the worry about rights. And, still according to the german point of view,
there
is no warranty that later anybody will come and ask for the payment of rights,
still thinking that currently there is no
Robert,
i'm writing new app using a database created by another programm (let's call
it AT). I'd like both apps (mine and AT) were able to run together on a local
machine. In my app i use superserver and FB 2.1 but the AT uses fbembed.dll
(embedded Firebird)(ver 1.5.5.4926).
My question is:
How can I know if a have differences changing from a null value to any value
(not null)
example:
old.idnomencladoraux = null
new.idnomencladoraux = '420101'
or
old.idnomencladoraux = '420101'
new.idnomencladoraux = null
works fine
old.idnomencladoraux = '420101'
The trigger is like this:
What is the TRIGGER declaration, what table? BEFORE or AFTER??
if (updating or (deleting) ) then
begin
select max(f_acd_id) from table1 into :maxID;
nid = old.f_acd_id;
while (nid :maxid) do
begin
select first 1 balance from
Martijn,
I was looking for a SQL expression, or maybe I need to create a UDF to
do some thing like:
SELECT SUM_EX(Age) FROM Persons
In any case, thank you for your prompt reply.
Are UDFs on groups of records even possible?
I am pretty sure you have deliberately asked a
Thanks for the advise but I don't think that is the issue. If you remove the
second select statement it compiles and runs fine.
Actually, that is the issue.
It is the 2nd SELECT which is the problem, so by removing it, you removed the
problem.
To invoke the SendMail UDF, you should
If it is HP, then you will probably have to enable HDD caching on RAID driver
... even if you do not use RAID there is this option in HDD driver.
As long as you are referring to activating READ caching, then that's fine.
Activating WRITE caching without a protected controller cache will
Two things come immediately to mind:
In addition to Doug 2 items, there is one other item:
Garbage Collection -- Due to the MVCC nature of the engine, SELECT queries can
find back-versions of records which need to be cleaned up. Depending on the
version (Superserver, Classic and
Tomasz,
Conclusion: using select 1 ... instead of select * ... in the sub-select
doesn't
improve anything, while using select first(1) ... even slows things down a
bit.
IMHO, that proves FB handles the sub-selects in an efficient manner, i.e.
doesn't retrieve irrelevant data and exits the
The firebird rdb$fields stores nullability value of the domain/column. Then
the rdb$relation_fields ALSO store the nullability value of the
domain/column (this looks like the actual override). So firebird still doesn't
support overriding the not null constraint on the domain???
You make it
All,
We will be making changes to our network infrastructure, which will affect
network connectivity. So, these resources will be unavailable during this time.
Sean
[Non-text portions of this message have been removed]
As long as you place the DLLs in the same folder the application EXEs and
*not* a shared/common path (like System32) you will be fine.
Actually, with v.2.5, you can separate the embedded Firebird components
from the application components when you deploy. If you wish to have the
three
are you sure you can live with data loss in cause of system- powersupply- or
emergency-shutdown-errors?
our database is about 42gb. that is the cause why we`re backing up just once
a day. it has it`s own raid1-volume, and for performance reasons i am
planning to add a raid5 with 4 fast
401 - 417 of 417 matches
Mail list logo