Paginating searchs = performance problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 the query twice ??? first to get the total count, second
to get my page.

it's very heavy

Any one's suggesting better doing ?

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux