[postgis-users] multiple queries in one phpscript?

[Nicolas Ribot]

> How does this affect performance? are the queries executed when the
> javascript scripts are loaded into the browser or only when the chart is
> displayed in the browser?
>

The queries are executed when the PHP page is processed on the server,
before the web server is sending the response to the client.
According to your architecture, queries may be executed before the
entire page loads, ie, for a "normal" page:
client call to the page -> PHP processing: queries are run -> page is
sent to the client -> browser displays the page

if your page is using AJAX to display charts, then the queries will be
executed when the AJAX URL is called.

Nicolas