Subject RE: [firebird-support] Error in sorting big queries
Author Riho-Rene Ellermaa
Server is FB 1.03 and should be default installation. Is there some
version number also in message file

Riho Ellermaa

>
> The proper answer depends on server version, which you don't mention.
>
> The overall answer is that you have NO sort space configured
> on that system. It's using c:\winnt\temp in default of
> absent configured sort space and there isn't enough disk space there.
>
> With 85Mb of expected *output* from a sorted query you need
> to configure about 2.5 times that, or about 215 Mb.
>
> Note, sorts won't use swap space when they have run out sort
> space. They will just complain, as your customer noticed.
>
> Fb 1.5 will use available RAM for sorts, but 188Mb is nothing
> much at all.
>
> How you configure sort space depends on server version. It
> is all documented in the OpGuide (for IB and for Fb 1.0) and
> in the release notes (for Fb 1.5).
>
> As for the messages, looks as if you have a mismatched message file.
>
> h.
>
>