| email this FAQ to a colleague
Q: Is there a problem with Connection pooling and stored procedures? A: With connection pooling on, connections are returned to the pool, and tempdb is never freed with the connection. Therefore, before turning on connection pooling for SQL Server, it is strongly recommended that you turn off the option to create stored procedures for prepared statements. To turn off this option, double-click your store's system datasource in the ODBC Administrator in Control Panel and clear the Generate Stored Procedure for Prepared Statement check box. Important
If you turn connection pooling on and you do not turn off Generate Stored Procedure for Prepared Statement, your system may not work. For performance to improve, you must turn off Generate Stored Procedure for Prepared Statement for each ODBC datasource that the Commerce Server stores use. In addition, after you turn off the option for each datasource, you must restart IIS. - Chris Woodrow | Articles |  | Sep 15, 2005 - Building an Image Keyword System | | Unlike text-based file formats image files aren't made up of words, which makes searching for an image file by keyword difficult. Instead of being able to simply open the file to see what it contains, we're stuck looking at the text around it and other metadata to determine the image's meaning. In this article, Ziran Sun shows you how to build a simple database-based image keyword system that allows you to associate keywords with images and use these keywords to make finding images easier.
[Read This Article] [Top] |
| | | Feb 10, 2005 - A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1 | | Back in the days of classic ASP, if you were building a database-driven
web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server
(or some other enterprise-ready database) or invest a lot of time finding a way to deal with the
performance and scalability limitations of Microsoft Access. Luckily these days there's
another viable alternative: MySQL.
[Read This Article] [Top] |
| | |
|
