l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2006 Nov 14 12:43

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
[vox-tech] querying postgres from php
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[vox-tech] querying postgres from php

Hi everyone,

i have a large postgres table, that i am querying from php: specifically:

1. query the rule classes associated with a given ID
2. query for a set of rules within a given class
3. for each rule, query the reasons why that rule is enforced 

this results in about 60 'select ...' statements. Watching the queries as they 
are run from pgtop, i notice that they run serially and not all that fast.

Running the same set of queries from the psql command line client takes about 
5 seconds max. Therefore, I think that the problem may be in the overhead 
involved in executing each query- or some PHP/Apache thing. I have a full set 
of indices built on this table, and using 'explain query ...' yields no 'seq 
scans', suggesting (i think) efficient use of the indices.

Any thoughts on how one might approach this issue ? 

thanks in advance,

Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.