Hello-

I have a quick question. If you are using PHP with MSSQL, are tables locked when queries are run? We have several chron jobs that run at night, and I don't want php to lock a table because someone gets on the website and runs a query while the chron jobs are running. The php/mssql queries CAN'T intefere with the chron jobs. However, we've had a a few deadlock issues, and I just want to be sure php/mssql isn't causing the problem and that php/mssql isn't locking tables as it runs queries (some of the queries take a min or two to run).

Thanks,
Sledge

    I'm not 100% sure, but I think you have to specifically lock the tables/records/rows when a query is run. Otherwise, you wouldn't be able to have more than 1 person running queries at a time, and that would be silly.

      Write a Reply...