Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: Re: Re: How to structure applications using a RDBMS

by adamsj (Hermit)
on Jul 19, 2002 at 19:05 UTC ( #183384=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Re: How to structure applications using a RDBMS
in thread How to structure applications using a RDBMS

I don't disagree a bit with what you've said.

On the other hand, I think a developer shouldn't have to be told more than twice that:

SELECT DISTINCT(item) FROM a.table
can eat up a couple hundred gig of spool without blinking, but that
SELECT item FROM a.table GROUP BY item
goes by in the blink of an eye. You'd think that wouldn't be a major paradigm shift for them--but it is (okay, in one case I've been dwelling on lately). And it'd be even nicer to be heard the first time.

(This is an oversimplified example--the point being DISTINCT versus GROUP BY.)

adamsj

They laughed at Joan of Arc, but she went right ahead and built it. --Gracie Allen

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://183384]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2016-07-25 12:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?


















    Results (224 votes). Check out past polls.