Or you can use this one (previous one mabye to fixed). It allows for a
threshold that you can play with
// SP start ---
CREATE OR ALTER PROCEDURE CALC_VALS_ADV (
threshold float)
returns (
param varchar(50),
id integer,
val
Type 'sudo ./remove.sh' [Enter]
If you are in the same directory as the shell file.
Regards
Paul
Dunno if this is of any help. But you can make a SP like this
//-- SP START
CREATE OR ALTER PROCEDURE CALC_VALS
returns (
param varchar(50),
id integer,
val float)
as
declare variable v_param varchar(50);
declare variable
Then what could be the best way to reduce the database size?
All suggestions are appreciated.
With Best Regards.
Vishal
Hi all,
I'm trying to upgrade an app to v2.54 from v1.56 but there are some queries
that aren't planning the way they should.
I have this query:
Select Distinct a.col01Int, a.col02SmInt, a.col03SmInt, a.col04VarCh45
from dettbl b
Inner Join msttbl a on (a.col01Int = i.col01Int and
Hi all,
I'm trying to upgrade an app to v2.54 from v1.56 but there are some queries
that aren't planning the way they should.
I have this query:
Select Distinct a.col01Int, a.col02SmInt, a.col03SmInt, a.col04VarCh45
from dettbl b
Inner Join msttbl a on (a.col01Int = i.col01Int and
Hello Set,
Actually, the problem isn't with FK_dettbl, but with the A Natural. In a Master
detail relationship with 450K+ rows in the master and 800K+ rows in the detail,
that natural is a killer.
Thanks Again
Hi everyone!
This might not be a straightforward Firebird question, but I'm hoping there's
a feature I'm unaware of that can help me beyond plain-vanilla SQL.
I have two tables. The first is a list of names of critical parameters, and
the second relates certain object IDs, critical parameter
Actually, the problem isn't with FK_dettbl, but with the A Natural. In a
Master detail relationship with 450K+ rows in the master and 800K+ rows in the
detail, that natural is a killer.
The problem is that Firebird thinks that
PLAN SORT (SORT (JOIN (A NATURAL, B INDEX (FK_dettbl
is a
Ok, used the +0 and worked.
On v1.56 I was used with setting up a high granularity data column (col04Int -
part of the primary key) with a True/false (0/1) type of column
(ColDetSmIntFlag) to boost the selectivity of the index IXColDetSmIntFlag. I
kept the index with that configuration for a
Hi
Does FB2.1 run on windows 8 ...
I installed the last 2.1 version o a windows 8 tablet (8.1)
In trying to connect to my database with SQL Manager
I get Connection failed Server is stopped or unproper client library is used to
establish connection to the server
I have done the install a
12 matches
Mail list logo