Document ID:        10747.1
Creator:            DAGREEN
Subject:            Longs/Arraysize/LongChunk
Modified:           19 Nov 96 11:08:31


Longs/Arraysize/LongChunk
-------------------------
When executing a query that selects one or more LONG columns, Reports
always does a piecemeal fetch and, therefore, always fetches one row
at a time.  So, ARRAYSIZE is ignored in this case.

The LONGCHUNK setting specifies the size (in Kb) of each 'piece'. Its
default value is 10.  Since that represents the size of a memory buffer,
its limits are (1) 63 on Windows, (2) 9999 on Motif.
Summarizing: you can fetch a 2Gb LONG on any platform, but on Windows
it may take longer, since we're forced to get it in smaller pieces...

If the query doesn't select any LONGs, ARRAYSIZE is used (and LONGCHUNK,
of course, ignored). In each round trip, Reports will fetch as many rows
as fit in a buffer 'ARRAYSIZE' Kb big.  The limits are 1-63 on Windows
and 1-9999 on Motif.