Max Pooled Statements

[Head, Joanne (Jo-Anne), ALABS]

I have a question, hoping someone can give an answer.

In the CF Admin documentation for CFMX, I see this:

Max Pooled Statements

Enables reuse of prepared statements (that is, stored procedures and
queries that use the cfqueryparam tag). Although you tune this setting
based on your application, start by setting it to the sum of the
following:

    * Unique cfquery tags that use the cfqueryparam tag
    * Unique cfstoredproc tags


My question is,
If you are not using cfqueryparam, and
If you are not using cfstoredproc,

What should you set Max Pooled Statements to?  How about "0"?

This is a CFMX 6 app server running on Windows2000 with a SQL Server
2000 DB.

Thanks in advance,

Jo-Anne

------------------------------------------------------
Jo-Anne Head, Website Developer / Senior Project Manager AT&T Labs:
Technical Information Design and Development tinarock@... // (732)
420-3423 mobile text messaging: <http://www.vtext.com/> /
TINAROCK@...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1848
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54