The most common cause of sluggish performance is badly written SQL, especially if it is written against a non-normalized database.
If the queries are badly written, putting them in stored procedures won't help much. As some else suggested, check for indexes. Also, remove any unnessary joins. If you have an analyzer, run it against the queries and see what it suggests. If you don't have one, there is a free one you can download here: http://manageengine.adventnet.com/products/applications_manager/db2-management.html On 1/17/06, Jillian Koskie <[EMAIL PROTECTED]> wrote: > Using DB2 8... other than obvious security and simplicity benefits will I see > noticeable speed gains if I convert regular queries to stored procedures? > > Any other tips (pointing me to resource material to read for myself is cool > too) for inscreasing SQL performance? I may know most of them already but > I'm hoping for a few pearls. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:192913 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
