Skip site navigation (1) Skip section navigation (2)

Re: faster output from php and postgres

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Mukta Telang <mukta(at)darya(dot)nio(dot)org>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: faster output from php and postgres
Date: 2003-05-23 16:04:09
Message-ID: Pine.LNX.4.33.0305231003070.27073-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-phppgsql-sql
It's probably just a slow query.

Could you print out your query in PHP to the web browser, then cut and 
paste it into the psql monitor to get an explain anaylze output?

i.e.
psql dbname
#> explain analyze select .... rest of query goes here;

And give us the output of that?  Thanks.

On Fri, 23 May 2003, Mukta Telang wrote:

> Hi,
> I am dealing with a database with many-to-many relation and have a php
> script that joins these tables and displays the output.
> But the problem is that after entering some 50 records the output is
> very slow!
> I can count till 50 before the script produces the output!
> The complete description of the problem is written below..
> Thanks in advance,
> Mukta
> 
> 
> 
> 
> description in detail:
> 
> 
> database part:
> 
> Three tables: paper,author and author_paper
> 
> "A paper has many authors and an author has many papers."
> In this way there is many to many relation.
> 
> The attributes of paper are: paper_id (primary key),title,journal,year
> etc
> 
> The attributes of author are: author_id(primary key) and name
> 
> The attributes of author_paper are: author_id ,paper_id and level
> ( author with level=1 is the main author of the paper )
> 
> 
> 
> php part:
> 
> For an author:
> 1. get author_id from author table
> 2. select all paper_ids from author_paper table
> 3. For each of the above selected paper_ids:
>         a. print all the attributes of paper
>         b. select all authors of the paper and print their names in the
> order
> of their "level"
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 


In response to

Responses

pgsql-php by date

Next:From: Frank BaxDate: 2003-05-23 16:49:37
Subject: Re: faster output from php and postgres
Previous:From: scott.marloweDate: 2003-05-23 15:58:32
Subject: Re: Number of connections

pgsql-sql by date

Next:From: Frank BaxDate: 2003-05-23 16:49:37
Subject: Re: faster output from php and postgres
Previous:From: Achilleus MantziosDate: 2003-05-23 15:43:09
Subject: Re: language "plpgsql" does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group