Hello,
I'm trying to optimize a request and cannot explain what I observe.
I have a relatively simple request using 3 tables returning around 1.8M
rows. On each table I have an index on: the primary key (ascending,
unique), the foreign keys (ascending) and the primary key (descending).
I'm
On 08/04/2015 19:44, andrew_s_...@yahoo.com [firebird-support] wrote:
After more than a decade of Firebird I'm more than used to using the
+0 to get the results desired from the engine
I'm used to writing compilers, in which world it is inconceivable that a
+ 0 wouldn't get optimised
At 08:05 a.m. 8/04/2015, moegama...@gmail.com [firebird-support] wrote:
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
Did you tried with firebird 2.5.x on it
you can also inspect for issues on starting services in event viewer also
firebird log should contain the error
great thanks
to make sure I've got this right
starting with the same database I can do either
a) gbak with gc
b) gbak without gc and gfix -sweep
and I will have the same final result
Extending this further, how can identify which tables contain (or did
contain) the garbage.
Number
On Apr 9, 2015, at 11:01 AM, Nick Upson n...@telensa.com [firebird-support]
firebird-support@yahoogroups.com wrote:
to make sure I've got this right
Not quite.
starting with the same database I can do either
a) gbak with gc
Won't advance the oldest active
b) gbak without gc and
great thanks
to make sure I've got this right
starting with the same database I can do either
a) gbak with gc
b) gbak without gc and gfix -sweep
and I will have the same final result
Extending this further, how can identify which tables contain (or did
contain) the garbage.
As well as
SELECT
Table1.ID, Table1.FKID, Table1.MD... some other fields
FROM Table1, Table2 , Table3
WHERE 1 IS NOT NULL
AND (Table2.ID = Table1.FKID)
AND (Table2.FKID = Table3.ID)
AND (Table3.ComputationID = 9)
ORDER BY Table1.ID ASC;
I'd welcome any insight as to what I might be doing wrong.