Re: [PHP] Paginating searchs = performance problem

2006-10-26 Thread Richard Lynch
On Mon, October 23, 2006 8:58 pm, Chris wrote: > Richard Lynch wrote: >> On Fri, October 20, 2006 10:04 am, Fourat Zouari wrote: >>> I have PHP/PostgreSQL application were i got a search page with >>> some >>> items >>> to search, am building the search query on server side. >>> >>> I need to displ

Re: [PHP] Paginating searchs = performance problem

2006-10-23 Thread Chris
Richard Lynch wrote: On Fri, October 20, 2006 10:04 am, Fourat Zouari wrote: I have PHP/PostgreSQL application were i got a search page with some items to search, am building the search query on server side. I need to display a paginated search and for this i need to get the total count of line

Re: [PHP] Paginating searchs = performance problem

2006-10-23 Thread Richard Lynch
On Fri, October 20, 2006 10:04 am, Fourat Zouari wrote: > I have PHP/PostgreSQL application were i got a search page with some > items > to search, am building the search query on server side. > > I need to display a paginated search and for this i need to get the > total > count of lines matching

[PHP] Paginating searchs = performance problem

2006-10-20 Thread Fourat Zouari
I have PHP/PostgreSQL application were i got a search page with some items to search, am building the search query on server side. I need to display a paginated search and for this i need to get the total count of lines matching the search before OFFSET/LIMITing my page, am i obliged to repeat th