18.08.2014 23:39, 'Carlos H. Cantu' wrote:
LSSBcfs While this would avoid the error, you will not know when/if your
change will be applied.
LSSBcfs A connection can hold an object in use for an indeterminant period
of time.
Dmitry said to me sometime ago that procedures changes will be
18.08.2014 22:51, Aldo Caruso wrote:
For reliability reasons, I decided to turn on forced writes on a
database running on Linux.
What is FB architecture: SS / CS / SC? I suspect SS given your default
cache size (2048 pages) but it's worth double checking.
1) Does it makes sense to activate
WD my Cloud it enables smb/cifs protocol so a network share can be mapped as
drive In Firebird 2.5.x is possible with
RemoteFileOpenAbility 1 in the firebird.conf (With a few big warnings if you
read the conf file)
you need to take care only the Firebird server to have access to that
DYdusnfs It's not about when your DDL is applied but about the cached procedure
DYdusnfs BLR that is used by others. The changed (new) procedure BLR will be
used
DYdusnfs by newly compiled statements immediately after your DDL has been
DYdusnfs executed. However, all already compiled statements
Hi,Thanks for you reply.
If I understand correctly, WD Cloud come with password to access private folder.
So, I am planing to install FB server where NAS attached and set private folder
in NAS, then map this folder as a network drive.
Other users, don't have direct access to this private
Sean,
thanks for your answer.
Aldo
El 18/08/14 a las 15:59, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] escibió:
Given this scenario my questions are the following:
1) Does it makes sense to activate forced writes on Linux ?
Different versions of Linux file systems
Rich,
I got the point: with forced writes off you can't be sure of when the
data is sent to disk.
But, in that case, what is the point of turning it off ? If you must
wait for the server shut down to be 100% sure that the data is written
to disk, isn't the risk too high to have forced write
Dmitry,
Your guess is correct: Super Server architecture.
Reliability in this context means for me having no database
corruption after a power failure or kernel panic.
Aldo Caruso
El 19/08/14 a las 06:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] escibió:
Carlos,
I agree with you. The performance degradation was very high on an
ext4 file system ( which has barrier enabled by default ). On the other
hand, I found no noticiable performance degradation on an ext3 file
system ( which has barrier disabled by default ).
Having barrier
Afair, in previous talks, Ann suggested that if you have to choose one or
another, choose FW ON.
The best thing would be if someone could simulate some crashes (like power
failure) in both configurations and report back about existence of corruption.
Unfortunately, it is not always
Hello.
Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
PROCEDURE without _*closing all conections and restarting the FB
service.*__*
*_
I guess that the problem could be related to my application leaving some
transaction, that uses the SP, without commit/rollback or
19.08.2014 21:56, Hugo Eyng wrote:
Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
PROCEDURE without _*closing all conections and restarting the FB
service.*__*
You can.
I notice that i am not the only one facing this trouble:
Help my frields!
Hard to help, when there's no question...
Looking back the thread, you got some answers but did not relate on them
in your following questions.
Does
select
sum(iif(extract(weekday from t.DATAB) = 0, PRODUTO, 0)) as W0,
sum(iif(extract(weekday from t.DATAB) = 1, PRODUTO, 0)) as W1,
I am I including the original question in case someone has better answer
I am assuming that if you have 2 produtos for the same time period that you
will want both of them displayed in the same row like so “CEBOLA,AJO”.
SELECT HORA, COALESCE( LIST(SEG),0) seg, COALESCE( LIST(TER),0) ter,
16 matches
Mail list logo