Subject Re: ORDER BY on large VARCHAR columns
Author robert_difalco
--- In, "Ann W. Harrison"
<aharrison@i...> wrote:
> How many records are you retrieving? Do you measure the time it
> takes to retrieve all the records or only the time it takes to
> retrieve the first? Do you normally retrieve all the records
> you select or only the first few?

It could be 2 or 3 hundred thousands. The table itself may have
millions. Let's say a query could return 200,000 and we do a
FIRST...SKIP query getting only 15 at a time. The page size is user
configurable, but it defaults to 15 in each page. Btw, this is with
1.0 on Solaris and 1.03 on Windows.