| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Ricky Prasla <praslar(at)hotmail(dot)com> |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Select Query Performance |
| Date: | 2003-06-02 01:48:31 |
| Message-ID: | 1054518510.77081.4.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 2)Also, I execute this query over the web. If there are mltiple select
> queries then I have to execute one get its reultset and then send the other
> one. Is there a faster way to execute multiple select queries over the web?
Going with the assumption the result-set is not used to generate further
queries, you might look into the use of Asynchronous connections.
It'll enable you to easily establish several connections to the database
for parallel work to be done.
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=libpq-connect.html
Even PHP will let you use the Asynchronous query mechanism within
PostgreSQL.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Papastamatopoulos | 2003-06-02 04:56:18 | FW: Query Plan problem |
| Previous Message | Ricky Prasla | 2003-06-02 01:12:54 | Select Query Performance |