At 02:57 PM 3/8/2002 -0500, Xavier Solé wrote:

>hello...
>
>I've made some progress in my problem... I have deleted almost all of the
>18000 records of teh table "RawData", and have left the table "Spot" as usual
>(with 9000 records more or less). Now my query returns only 8 records, and
>everything has worked fine. It seems that there is an internal limitation of
>the size of these temporary files. Please could anyone tell me how I can
>override this limitation?

Be sure you have enough space in /tmp or define other temporary directories
in your IBCONFIG file. The behavior of InterBase and Firebird is slightly
different in this area. Versions of InterBase prior to 6.5 (which I haven't
tested) would create sort temporary files larger than 4Gb and then not be
able to use them. Firebird does not. But your problem is much more likely
to be that there isn't enough room for the sort file than that the sort file
exceeded our limit.


Regards,

Ann
www.ibphoenix.com
We have answers.