[Resolved] ADODB / Postgres quessie

[melody]

Hi

I've got a little design problem which probably has a simple soltuion... (i hope!!)

I want to make a search script which searches the database and returns results. That bit is easy enough. However, I want the page to be able to say "Found 129 results" for example. I also want to use a limit clause, so that I can just view records 1-20 or 21-40 of the results etc. The problem is, when I set this clause the program says "Found 20 results". The only way I can think of doing it is with 2 calls, but I obviously don't want to do this for performance reasons... Is there any way I can do this? I'll be using the ADODB abstraction layer.

Sorry if I've rambled on, it was kinda hard to explain 🙂 !

Thanks,
Melody

[Sxooter]

While there are ways to do it with a funky union setup, it's no faster to try and combine the two queries into one than it is to just run the two. Note that since you're running basically the same query twice, all the data should still be in the buffers, so the second time through should be pretty fast as long as the query isn't horrible complex.

Make sure whatever where clause you have is using indexes and you'll be ok.

[melody]

Many thanks for the advice 😃