| Subject | Re: ORDER BY on large VARCHAR columns |
|---|---|
| Author | robert_difalco |
| Post date | 2004-10-27T15:09:27Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
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.
<aharrison@i...> wrote:
>It could be 2 or 3 hundred thousands. The table itself may have
> 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?
>
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.