Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

what's a better code design priciple?

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.


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

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

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /