|
|
Posted by Joshua Ruppert on 12/17/38 11:54
Chung Leong wrote:
> I was just doing some testing on the SQLServer ODBC driver for
> something I was working and I noticed that retrieving rows through the
> odbc functions is incredibly slow compare to using the mssql functions.
> We're talking about an order of magnitude difference. I wonder if your
> script was simply running very slowly and hadn't actually stalled. Try
> timing how long it takes to retrieve all rows from a particularly large
> table in a couple test scripts, once with ODBC and then with the mssql
> functions.
Thanks for the info. I will look into that and the "long query option".
I really appreciate the tips.
I'm going back and forth with my boss about what could be causing these
stranded processes. We're not sure if the problem comes before or after
the DB connection. The connections that can be viewed from SQL Server
seem to be recycled properly, even if they get into back log is seen of
them. They seem to go away after a maximum of about 10 min.
Conversely when a PHP process is stuck for longer than the max
execution time, I've never seen them be recycled. Though one of our
problems is that we don't know when the PHP processes were started
versus the start of the DB connect. So we don't know how long they have
been sitting, but we have highlighted some of them and waited 15 - 20
min without them going away. Do you know if the process start time
stored anywhere under the hood in Windows?
Navigation:
[Reply to this message]
|