w2k3 server + mysql +php

[TTT]

Problem is that windows 2003 server is REALLY slow when executing query (timeout's when over 10 query's). If template doesn't contain any query, it work's as it should.

mysql = 4.0.13
mysql-odbc = 3.51
php ver = 4.3.2

[Sxooter]

Anything in MySQL's logs to tell you what's taking so long?

How long do you queries take if you run them by hand from the mysql prompt?

[TTT]

queries execute time is something between 0.12-0.16
even mysql_test gives same result but text is printed on screen like slowmotion

[Sxooter]

Try storing a microtimestamp in an array between every statement, then echoing them out.

function getmicrotime(){ 
    list($usec, $sec) = explode(" ",microtime()); 
    return ((float)$usec + (float)$sec); 
    } 

$time[]=getmicrotime();
$conn = ....
$time[]=getmicrotime();
$res1 = mysq_...
$time[]=getmicrotime();
$res2 = mysql...
$time[]=getmicrotime();
...

print implode("<BR>",$time);

and see what you get.