Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

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

by adamsj (Hermit)
on Jul 19, 2002 at 19:05 UTC ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://183384]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2024-03-28 17:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found