Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpolation
Date: 3 May 2007 05:58:47 -0700
Message-ID: <1178197127.705074.304370_at_y5g2000hsa.googlegroups.com>
Cimode is arguing that as long as it works, one query is as good as another. If we were in a procedural language, Cimode would be saying "Bubble sort, Quicksort! what's the difference?"
Selzer is arguing that the complexity of one query can be higher than another -- algorithmic complexity. If we were in a procedural language, Selzer would be saying "Bubble sort is O(n^2) and Quicksort is O(n ln2 (n)), that's the difference!"
Selzer is right. Complexity happens to effect execution times, but it is more abstract than just reading a stop watch. At some point, you cannot throw hardware at a problem and need to use another tool.
>> .., so I had to improvise in order to implement a transition constraint.<<
I have an article in www. dbazine.com on implementing transition constraints with auxiliary tables and DRI actions. No need for triggers. Received on Thu May 03 2007 - 14:58:47 CEST