Thank you very much, Thomas. Very useful.
Greetings.
Walter.
On Tue, May 26, 2015 at 1:02 PM, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Hello Walter,
Hello Thomas
That seems an interesting idea. Can you explain it with more
Thank you guys for your ideas, I will look onto them.
Possible further enhancements during index re-creation would be to
re-create several indexes in parallel becoming more and more IO bound,
especially with low latency storage. AFAIK InterBase added something
like that in a recent version. Potentially Firebird has that on the
roadmap as well.
Thank you for sharing this knowledge with us. Very good things to learn.
-Halim
At 04:47 a.m. 27/05/2015, johnpayton...@btinternet.com [firebird-support] wrote:
Have downloaded Firebird SS2.5.4 and new user was set up but can't access any
commands from either my or Firebird user.
Neither will give you access to a Firebird server. To get you started, you
need a client
25.05.2015 13:25, Stefan Heymann wrote:
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
It means that the role wasn't actually applied (even if it was
specified). Maybe
25.05.2015 17:43, Hugo Eyng hugoe...@msn.com wrote:
1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
NEW_COLUMN INTEGER NOT NULL). There were already some records in the
table. FB didn´t raise any warning or exception.
2 - I created a backup file from MYDB.FDB using gbak.
Hi,
the real question is in point 4
tables
CREATE TABLE TABLEX
(FIELD_ID INTEGER
);
CREATE TABLE TABLEY
(
ID INTEGER,
AAA INTEGER
);
CREATE TABLE TABLEZ
(
ID INTEGER,
BBB INTEGER
);
few thinks:
1. If i do something like this
SELECT (SELECT P.SUM_AAA FROM MY_PROC_CALC(T.FIELD_ID) P) FROM
Hello,
is it possible by using CAST or in any other way to get database error when
casting such number to integer?
SELECT CAST('13.245' AS INTEGER) FROM RDB$DATABASE
This gives 13 but instead I would like to get an error because precision is
lost.
However, I would like to NOT get an error when
Encryption is at volume level and done by a TPM chip so the overhead should be
low
here are some numbers for io
Developers: How does BitLocker affect performance?
http://stackoverflow.com/questions/2762844/developers-how-does-bitlocker-affect-performance
3. when i change proc to use execute statement with parameters
SET TERM ^ ;
CREATE PROCEDURE MY_PROC_CALC_EXEC_PARAM(ID INTEGER) RETURNS(SUM_AAA INTEGER)
AS
DECLARE VARIABLE VAR_SQL VARCHAR(1000);
BEGIN
VAR_SQL = 'SELECT SUM(AAA) FROM TABLEY WHERE ID=:ID';
EXECUTE STATEMENT (VAR_SQL) (ID :=
Here you change the SQL for each iteration, hence I cannot see how it would
be possible to prepare only once. What you could try, is to use a temporary
table, change your statement to:
Simple if after iteration query look like
SELECT * FROM TABLE WHERE ID=?
SELECT * FROM TABLE WHERE ID=? OR
Hi,
this is simple with case or iif
this run ok
SELECT CASE WHEN CAST('123.00' AS INTEGER)CAST('123.00' AS NUMERIC(18, 3))
THEN CAST('PRECISION LOST' AS INTEGER) ELSE CAST('123.456' AS INTEGER) END FROM
RDB$DATABASE
this run with an error conversion error from string PRECISION LOST FOR
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
Is there a way to find out the role another user (with a specifid
attachment_id) is logged in?
AFAIR, the MON$ROLE
On 20/05/15 21:15, Alexandre Benson Smith ibl...@thorsoftware.com.br
[firebird-support] wrote:
In this way wouldn't the SP have the same problem that was mentioned
by Louis, namely that only the index from the first table in the
query would be used?
I did not read it in full details...
Halim,
Thank you for your reply.
I just tested a GBAK restore using -se(rvice) switch on a 1 GB DB. It
took about 8 minutes. Restoring the same database using IBExpert took
about 3 minutes.
I'm looking for a faster restore time because I want to automate the
process using a batch file. Our
Thank you for your reply. I just tested a GBAK restore using -se(rvice) switch
on a 1 GB DB. It took about 8 minutes. Restoring the same database using
IBExpert took about 3 minutes.
I'm looking for a faster restore time because I want to automate the process
using a batch file. Our DB is over
Hello Thomas
That seems an interesting idea. Can you explain it with more details?
Greetings.
Walter.
On Tue, May 26, 2015 at 12:25 PM, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Halim,
Thank you for your reply.
I just tested a
Hello Dimitry.
I thought I was testing in FB 3.0, but I wasn´t. I am sorry.
I tried FB 3.0 now and _*it really raises*_ and error at step 1. Then I
use DEFAULT clause and it works like I expected.
Thanks for your answer.
Hugo
On 26/05/2015 03:08, Dmitry Yemanov
Hello Thomas.
Please see my answer to Dimitry.
Thanks for your answer.
Hugo
On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com
[firebird-support] wrote:
Hugo,
Hello.
1 - I created a column NOT NUL in a table (ALTER TABLE MYTABLE ADD
NEW_COLUMN INTEGER NOT NULL). There
Hello all,
I came across something really strange as far as restoring a Firebird
database. if I use IBExpert(a tool from HK Software) it takes about 3 hours but
if I use regular gbak using command line it takes 9 to 10 hours.
I'm using Firebird 1.5. IBExpert vesion 2008.08.08
I think I'm
Hello Thomas.
I saw Dimtry´s comment.
About the DEFAULT CLAUSE, even provided, it acts only on new rows and
not on preexisting rows. Is this true?
Hugo
On 26/05/2015 02:53, 'Thomas Steinmaurer' t...@iblogmanager.com
[firebird-support] wrote:
Hugo,
Hello.
1 - I created a column NOT
Have downloaded Firebird SS2.5.4 and new user was set up but can't access any
commands from either my or Firebird user.
have tried as suggested
export FIREBIRD_HOME=/Library/FRameworks/Firebird.framework/resources
export PATH$PATH:$FIREBIRD_HOME/bin
I have used Pascal and Microsoft Access
Once again thank you. I am very sorry it has taken me so long to reply.
On 20/05/15 21:19, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
1) Re the separate database: nobody said you shouild do it from your
own. I'd do it in the client, once the original data has been
Hello all,
I came across something really strange as far as restoring a Firebird
database.
if I use IBExpert(a tool from HK Software) it takes about 3 hours but if I use
regular gbak using command line it takes 9 to 10 hours.
I'm using Firebird 1.5. IBExpert vesion 2008.08.08
I think I'm
Hello Walter,
Hello Thomas
That seems an interesting idea. Can you explain it with more details?
For the restore process, gbak supports a -BU(FFERS) switch to override
the database page buffer value. While page buffers tends to be rather
small for Classic/SuperClassic hosted databases, you
26 matches
Mail list logo