Re: name search query speed

> -----Original Message-----
> From: Jeremiah Jahn [mailto:jeremiah(at)cs(dot)earlham(dot)edu]
> Sent: Thursday, March 03, 2005 2:15 PM
> To: John A Meinel
> Cc: postgres performance
> Subject: Re: [PERFORM] name search query speed
>
> [...]
> So the count for this is generated on the fly needed for
> pagination in the app which expresses the total number of
> finds, but only displays 40 of them. If any one knows a way
> to determine the total number of matches without needing to
> iterate through them using jdbc, I'm all ears as this would
> save me huge amounts of time and limit/offset would become
> an option.

Is there a reason you can't do a count(field) query first? If
so, you can get the number of records returned by setting
absolute(-1) and getting the row number.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East, Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129