Re: [PHP] Re: Paginating searchs = performance problem

2006-10-23 Thread Richard Lynch
On Mon, October 23, 2006 4:55 am, Ivo F.A.C. Fokkema wrote: > For my projects I use MySQL anyway, and this one even bypasses the > LIMIT > clause, according to the MySQL manual. All I have to do is check if my > users are using MySQL >= 4.0... That's been released for a while, but > you > never kno

Re: [PHP] Re: Paginating searchs = performance problem

2006-10-23 Thread Ivo F.A.C. Fokkema
On Mon, 23 Oct 2006 04:33:52 -0400, Robert Cummings wrote: > On Mon, 2006-10-23 at 10:13 +0200, Ivo F.A.C. Fokkema wrote: >> On Fri, 20 Oct 2006 12:06:26 -0400, Robert Cummings wrote: >> >> > On Fri, 2006-10-20 at 17:22 +0200, Ivo F.A.C. Fokkema wrote: >> >> On Fri, 20 Oct 2006 17:04:35 +0200, Fo

Re: [PHP] Re: Paginating searchs = performance problem

2006-10-23 Thread Chris
Robert Cummings wrote: On Mon, 2006-10-23 at 10:13 +0200, Ivo F.A.C. Fokkema wrote: On Fri, 20 Oct 2006 12:06:26 -0400, Robert Cummings wrote: On Fri, 2006-10-20 at 17:22 +0200, Ivo F.A.C. Fokkema wrote: On Fri, 20 Oct 2006 17:04:35 +0200, Fourat Zouari wrote: I have PHP/PostgreSQL applicat

Re: [PHP] Re: Paginating searchs = performance problem

2006-10-23 Thread Robert Cummings
On Mon, 2006-10-23 at 10:13 +0200, Ivo F.A.C. Fokkema wrote: > On Fri, 20 Oct 2006 12:06:26 -0400, Robert Cummings wrote: > > > On Fri, 2006-10-20 at 17:22 +0200, Ivo F.A.C. Fokkema wrote: > >> On Fri, 20 Oct 2006 17:04:35 +0200, Fourat Zouari wrote: > >> > >> > I have PHP/PostgreSQL application

Re: [PHP] Re: Paginating searchs = performance problem

2006-10-23 Thread Ivo F.A.C. Fokkema
On Fri, 20 Oct 2006 12:06:26 -0400, Robert Cummings wrote: > On Fri, 2006-10-20 at 17:22 +0200, Ivo F.A.C. Fokkema wrote: >> On Fri, 20 Oct 2006 17:04:35 +0200, Fourat Zouari wrote: >> >> > I have PHP/PostgreSQL application were i got a search page with some items >> > to search, am building the

Re: [PHP] Re: Paginating searchs = performance problem

2006-10-20 Thread Robert Cummings
On Fri, 2006-10-20 at 17:22 +0200, Ivo F.A.C. Fokkema wrote: > On Fri, 20 Oct 2006 17:04:35 +0200, 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 paginate

[PHP] Re: Paginating searchs = performance problem

2006-10-20 Thread Ivo F.A.C. Fokkema
On Fri, 20 Oct 2006 17:04:35 +0200, 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 t