January 24, 2003
Oracle v SQL Server, Part 7
OK, I will admit it, this frightens me. It is saying, in effect, to not run any form of processing in the database.
I can attest to the truth of this though. I wrote a batch update script in T-SQL and started it up on our database. Twenty four hours later it was still running. So we killed it. After looking at this paper I figured that whilst I may be able to optimise my script it would still take an age to run.
So I stripped out the SQL statements and re-wrote the logic in Python. It then took fifteen minutes to run.
There is a lesson to be learnt here, but I cannot bring myself to believe that T-SQL is really that bad. Or is it?
Posted by Andy Todd at January 24, 2003 02:44 PM