OK, I'm writing a front end to an insurance quotation system, (itself written in CF and MS sql server). Because of the legacy of the muppet who built the first release of the system, a lot of calls to the database are made executing simple sql queries, subsequently looping round those queries and executing nested queries again and again and again... I'd do it differently, but have to admit some of my reasoning behind that is down to good old fashioned hindsight, Wisdom vs Knowledge etc.
Anyway, to help improve the performance of the various insurer quotation engines, I want to do some basic stuff like query caching and using stored procedures wherever possible (I don't think there's even one query in the whole system that even has cachedwithin written in the cfquery tag!). Obviously the only queries I can cache will be ones without any parameters being passed. That ain't a whole lot, so instead, I'm intending on writing stored procs. My question is: What's the best book for someone like me who somehow knows ansi sql to a fairly reasonable standard (vertical joins - i.e. unions, horizontal joins i.e. inner/left/right, cartesian products, sub queries, correlated sub queries, aggregate functions and grouping) but has NO experience of writing nice elegant stored procs, triggers. I want a really good SQL book only covering MS SQL Server, not teaching you how to write basic queries, but not assuming you're a DBA... I am interested in finding out how to optimize sql statements and the database in general from the viewpoint that it will always be used in the context of CF calling upon it to do stuff... the front end is written in FB3 of course!!! Recommendations please! Ta David _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
