PEAR and timeouts

[Anon]

OK... I'm using the PEAR database abstraction class in an application I'm writing, and it was fine before I started with the PEAR DB class. However, now on some pages I'm continually getting "Maximun execution times exceeded" messages, pointing to seemingly random lines in PEAR.php. What could be causing this? I'm thinking along the lines that all of the includes (PEAR includes are ussually fairly big files) are slowing it down and it's causing the timeouts.

Any other possibilities?

--Jason

[toma42]

Probably not the includes (possible if you have a slow server though)...what db are you using? Have you set up a watch for big queries?

[Anon]

Well, when I use it with MySQL, it is fine, but when I use it with MS SQL (the same queries), it gives me the timeout. I get the error (the timeout message) ussually with lines 222 and 500 of PEAR.php. And the query is not very big at all.

I'm working through the code as I type this message; I think it has more to do with the way that the PEAR database abstraction class returns DB_Result classes with the fetchRow() method.

--Jason

[toma42]

Have you tested the queries outside of php? I would try dumping the sql rather than running it so you can then run the sql by hand and even run explain on it to see why it's taking so long.

It could be pear too, I suppose, but the first place I'd check is the sql.