> > 2 queries vs 1. i win. > > Only if your one query is faster than my two!
logic dictates that one of your query's is verity based & slower. verity performance is flat, sql server's benefit from caching, they (they as in the same ones repeated) get faster. > Well, that only works if you store the files on the local filesystem of the > database server, right? That won't help if they're somewhere else, like the > filesystem of the web server, will it? actually i *think* (as i actually haven't done it) its possible, either that are in some combo with indexing. or maybe by simply mapping those drives. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
