Subject Re: Memory issue with text blob (blob sub_type 1) query
Author dkeith2
Statistics output from flamerobin running on the server:

Starting transaction...
Preparing query: SELECT p.ATAG
FROM PARSE_HTML_TAGS p
Prepare time: 00:00:00.
Field #01: PARSE_HTML_TAGS.ATAG Alias:ATAG Type:STRING(255)
PLAN (CP_MONO_MAIN_PATI_ NATURAL)SORT ((A NATURAL))(TEMP NATURAL)


Executing...
Done.
1305436 fetches, 299224 marks, 401 reads, 777 writes.
73056 inserts, 0 updates, 12 deletes, 64 index, 737 seq.
Delta memory: -1958666432 bytes.
TEMP: 73056 inserts. 12 deletes.
Execute time: 00:00:25.

--- In firebird-support@yahoogroups.com, "dkeith2" <dkeith2@...> wrote:
>
> Server version is Classic 2.1.x
>
> --- In firebird-support@yahoogroups.com, "dkeith2" <dkeith2@> wrote:
> >
> > I have a procedure where I query the following table:
> >