Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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 chilling in the Monastery: (14)
As of 2014-07-28 14:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (200 votes), past polls