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 display a paginated

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 the

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

[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