Am 19.08.2014 um 18:30 schrieb 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support]:
Re: [firebird-support] Forced write, page size and buffer size The
best thing would be if someone could simulate some crashes (like power
failure) in both configurations and report back about existence
I never said it would cover all possibilities. I just said that
instead of guessing or stay only with the theory, a real test
could give more trustful results ;)
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
EHehdfs Am
The hard truth is that the only _absolute guarantee_ to prevent
database corruption is FW = ON.
Provided that the file system also has barrier enabled ...
Regards,
Aldo
I've a question regarding this, since the context has been in Linux.
I run 2.5.2 on a virtual Server 2008R2 machine.
Is FW on by default on this install?
If not, is that a setting in the conf file or do I need to use GFix
On Wed, Aug 20, 2014 at 9:05 AM, Aldo Caruso aldo.car...@argencasas.com
You can check whether forced writes status is on or off submitting on a
FB console the following command
SHOW DATABASE
In order to set it on / off, you shoud run
gfix -user [user_name] -password [psw] -w [sync | async] [database_name]
Regards,
Aldo
Thanks for the tip. I did take the default install and yes, FW is on.
On Wed, Aug 20, 2014 at 10:08 AM, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] firebird-support@yahoogroups.com wrote:
You can check whether forced writes status is on or off submitting on a
FB console the
Hi there,
As subject, is it possible to export a query result set to an external csv
file from a Firebird stored procedure? I know this can be done with IBExpert
but we are looking for a pure firebird sql solution. We are using Firebrd 2.5.
Any pointers on how to do this will be much
you could define an external table with 1 field, construct a csv within the
SP and write to the table
Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200
On 20 August 2014 17:19, conver...@gmail.com [firebird-support]
You want to be looking around your external CSV file being an external
table - that's the only way to write to files from stored procedures
AFAIK, so, no matter how convoluted the code ends up, that's probably
the approach you'll have to take.
(Unless there's new stuff in 2.5 I don't know
On Aug 20, 2014, at 9:05 AM, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] firebird-support@yahoogroups.com wrote:
The hard truth is that the only _absolute guarantee_ to prevent
database corruption is FW = ON.
Provided that the file system also has barrier enabled ...
I run 2.5.2 on a virtual Server 2008R2 machine.
Is FW on by default on this install?
FW is not a function of the install or server config, it is a database property
that is determined by the OS which was used to create the database*.
For all version of Windows the default = ON
I am not
Ann,
thanks for the correction. I erroneously missinterpreted that file
system barriers were also necessary.
Aldo
++
Visit
I thought I'd save some time by spending some money on XMLWizard to do
some CSV imports of data sets ... rather than pulling together my own
PHP scripts. It seems to work well enough on Windows, but I could not
get the Linux version working.
But the problem I've found is that while the date
13 matches
Mail list logo