Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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


Comment on Re: Re: Re: Re: How to structure applications using a RDBMS
Select or Download Code

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 cooling their heels in the Monastery: (15)
As of 2015-07-29 13:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls