> While on that subject, a lot of people insist that everythig > should be done with SP's wherever possible. > While this is indeed a good idea for long/complex queries > that will see vastly improved performance and speed, but I > think it is wrong to do it just for the sake of it, and to > put basic select or other small queries etc into SP's.
I wouldn't go so far as to insist, but I do strongly recommend it. Not for speed, primarily - using prepared statements may be as fast in many cases - but not just "for the sake of it" either. Using stored procedures allows you to logically segment data access code from your application in a useful way, and allows the application to be secured a bit more - you can in many cases essentially remove the ability to run arbitrary SQL from your application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4