On 2019-09-18 02:11, 'Andrew Zenz' and...@aimsoftware.com.au
[firebird-support] wrote:
> Firebird 2.5.7 (WI-2.5.7.27050)
>
> Just realised I 'should' be using 2.5.8, but on a server running
> WI-V2.5.8.27089 it still uses NATURAL.
Be aware, the latest version of Firebird 2.5 is 2.5.9, not
Thanks.
Excuse me while I find a brick wall to bash my head against.
Andrew Zenz
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, 18 September 2019 2:47 PM
To: firebird-support@yahoogroups.com
Hiyour problem is that you have ascending index, which is not usable in
descending queries. You need to create descending index and it then can be used
in e.g. max queries. Ascending index is used in min queries and order by xx
asc.Regards,Karol Bieniaszewski
null
and further, when I run the query in Flamerobin as it was in the
trace substituting 9 for the ?:
SELECT
"ID","USERNAME","USERNO","LOGDATE","LOGTIME","LOGFILE","RECORDKEY","RECO
RDACTION","RECORDBEFORE","RECORDAFTER" FROM "AIMLOG" WHERE ("ID" <=
99 ) ORDER BY "ID" DESC
I performed a trace and this is the result. I suspected it was doing an
order by:
Preparing Statement 5694738 : SELECT
"ID","USERNAME","USERNO","LOGDATE","LOGTIME","LOGTABLE","RECORDKEY","REC
ORDACTION","RECORDBEFORE","RECORDAFTER" FROM "AIMLOG" WHERE ("ID" <= ? )
ORDER BY "ID" DESC Time
Hi everyone.
I am experiencing an unusual situation.
I have a log table for tracking user changes to records. Table is as
follows:
CREATE TABLE AIMLOG
(
ID Integer NOT NULL,
USERNAME Char(12) COLLATE EN_UK,
USERNO Integer,
LOGDATE Integer,
LOGTIME Integer,
LOGTABLE
Martin,
Vlad head read my mind and answered :)
Try remote restore through service manager, it is much faster.
Regards,
Alexey Kovyazin
вт, 17 сент. 2019 г., 9:59 hv...@users.sourceforge.net [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
> ---In firebird-support@yahoogroups.com,
Hi Vlad,
> gbak is usual client application, it needs no special actions to use
> WireCompression. Just put zlib1.dll near the fbclient.dll and set
> WireCompression = true at client side (using firebird.conf or DPB). Make sure
> zlib1.dll is present at server side also.
Thank you. That’s the
On 2019-09-17 09:25, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
> Hello!
>
> Just a quick q to try to figure out if it's worth for me to use it as
> the basis of a greenfield, not-so-high priority, project I am working
> on.
>
> How unstable is FB4? Does it result in
Hello!
Just a quick q to try to figure out if it's worth for me to use it as the
basis of a greenfield, not-so-high priority, project I am working on.
How unstable is FB4? Does it result in tables' data corruption, for
example?
Or does that mean that it'll hang for "no reason", as it were?
Kind
---In firebird-support@yahoogroups.com, wrote :
> I often perform restores on remote servers via WAN. Since this sometimes
> takes a long time, I wonder if gbak > takes into account the parameter
> WireCompression. What needs to be set as where?
gbak is usual client application, it
11 matches
Mail list logo