Think about how much more crap you gotta send back to the app server if you do it in one query. Not to mention the fact that you're requestion to totally different types of data that have exactly zero to do with eachother.
Say you've got 50 authors. If you do a join, you're going to be pulling the full text of the article back across the network 50 times, rather than once if you do it with separate queries. No ifs, ands, or buts, two separate queries is the way to go. cheers, barneyb On Tue, 9 Nov 2004 13:08:05 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > I'm sorry I have to disagree... > I'd much rather make one call to the DB and get all of my results in 1 > query. It's faster. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
