Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

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