> Quick question for all the database gurus on the list, does > anyone know if > views perform better or worse than the equivalent query using > joins in a stored procedure? > > Also does this differ between database vendors?
OK, I'm talking from SQL Server experience here Stored Procedures are faster as it's "compiled" the SQL Views are faster than straight SQL as it already knows the SQL Be VERY careful of the results from SQL Server Views; sometimes they go corrupt and return nothing, so rebuild them (fairly) often - it's rather embarrasing when your site is returning no data, you've checked the database, only to find out that the View is corrupt and it's the only thing wrong! Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
