what's a better code design priciple?

[ccb at valinux.com (ccb at valinux.com)]

Christoph Doerbeck A242369 writes:
> Hey folks,
> 
> I am at a cross roads in the development of a little application.
> What's better in the interest of performance and (more importantly) code
> maintainability?
> 
> 	a) use multiple simple SQL queries requiring additional code 
> 	b) increase SQL complexibilty, use one query and reduce code size
> 
> Comments?  Obviously it's tough to gauge the best solution without knowing
> my design in detail, but I was wondering if there were some hacker
> standards I should go by...


Hackers and SQL?  Oh well.  If you're using an industrial strength
database like Oracle or DB/2 I'd be inclined to hand it to the
database and let the query optimizer sort it out.

Warning: I'm only qualified to play a db programmer on TV.

ccb


--
Charles C. Bennett, Jr.			VA Linux Systems
Systems Engineer,			25 Burlington Mall Rd., Suite 300
US Northeast Region			Burlington, MA 01803-4145
+1 617 543-6513				+1 888-LINUX-4U
ccb at valinux.com				www.valinux.com

-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).