Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpolation



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.

.



Relevant Pages

  • Re: OT: Education is a Right
    ... In essence I am saying that all the polarized rhetoric that goes on in the ... guaranteed rights by virtue of citizenship in this wonderful country" vs. "I ... Well, I may have overstated the idea just a bit for the sake of making a point, but I don't think when push really comes to shove the differences are quite that deep. ... I don't think I am. I'm challenging the assumption that these differences we are arguing about are as deep and clear as we tend to believe. ...
    (rec.gambling.poker)
  • RE: Using multiple 1 to 1 relationships
    ... record in TermInfo and then somehow working with OTHER tables in a view query ... In your second post you didn't describe / confirm your join types. ... You keep saying just "failure" without saying what the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Parameters in queries
    ... I believe that is exactly what I am saying, ... the 2nd query should use todays date instead of the parameter. ... ie both queries should use the same subquery not 2 separate ... WHERE BBIdentifier Not In (SELECT BBIdentifier ...
    (microsoft.public.access.formscoding)
  • Re: One-To-One Relationships
    ... Of course it isn't easy to query; ... I'm just saying I may not yet have ... don't exist outside of their attributes, good (that was a painful one ... Understanding the impact that object containment has on ...
    (comp.databases.theory)
  • Re: (politics) SD bans nearly all abortion, even for rape and incest
    ... AT THIS POINT ARE ARGUING TO ARGUE!!!! ... WHY ARGUE AGAINST IT!? ... WHAT IN THE HELL. ... hell his name is saying maybe right to him but not everyone else. ...
    (rec.music.phish)