optimizing maximum execution time

[ezra_undag]

hi,

im new here in phpbuilder.com.

i wana ask for help about optimizing execution time of php scripts

i had this error on my school project im working on:

"Maximum execution time of 30 seconds exceeded in www.//.."

i used postgresql for my dbms. i was trying to access a database from another computer within the LAN using dblink functions. i implemented views so that i can read relations from other databases using dblink functions.

i created php scripts reading from this views and presented them in tables and charts on html.

i encountered the above error.i managed to solve the prob by setting the max_execution_time=0.
however, it took a very long time to load the page and its contents especially the tables and charts containg values that are stored from the other database within the LAN.

how can i make it faster to load the page? how can i optimize the execution time?

pls do help me on this matter.
thanks

[bradgrafelman]

There are many techniques you can use to find what's taking the longest to execute in your script (though the name of one particular implementation I've seen escapes me...), but the problem is most likely your database. If the computer is on a LAN, it's probably not the transfer speed that is the issue but rather your queries/table structures. Thus, you might benefit from finding out what query/queries is/are taking the longest to execute and begin optimizing the DB.