I agree with the other people.  Your queries are the problem, not PHP.  For
all intents and purposes, PHP is probably waiting on MSSQL to return all the
data.  Remember SQL servers do the query processing, not PHP.

I have not used PHP with MSSQL so I am not sure what you can do, but odds
are you will want to take all those queries and make them predefined on the
SQL server and then call it from your PHP script.  Should run a lot faster.

I do agree also with others that with 50 queries for one html page seems
quite excessive.  You may want to rethink your application logic and/or
database structure.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Arya Asemanfar" <arsal@z...>
To: "professional php" <pro_php@p...>
Sent: Saturday, December 15, 2001 7:02 PM
Subject: [pro_php] Execution Time


> I have this long 700 line code that containts 50 MySQL queries and about
> 40 math formulas. PHP executes these formulas and queries up to 600 times
> to a data set. It takes about 1 second to do 2 rows, I need it to be
> faster, how do I increase execution speed? Any help would be appreciated.
>