> Interestingly the upcoming SQL Server Express is limited to > one processor, but MSDE is not. MSDE is limited to 25 (?) > concurrent connections but as I understand it all connections > are made thru CF so the number of connections you will use is > a total of one.
While CF will use the same connection string, assuming you're using a single datasource, username and password, it will make more than one connection in most cases. All queries within a single page using the same connection string will use the same connection, but if two pages are run simultaneously, CF will create a second connection because the first one's in use. By default, CF will create as many connections as it needs, although it will reuse connections if they're available. So it's not impossible that you may bump into the MSDE connection ceiling, especially if you're using multiple databases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
