some limitations (well at least there used to be...)
MSDE will
----------
1. Support up to 2Gb RAM.
2. 2GB database size limit - this can restrictive if you have a text
datatype heavy DB
3. Supports up to 2 CPU on Windows NT or Windows 2000 box.
4. Has No publishing for transaction replication.
5. No Database Server Failover Support.
6. No Full-text search.
7. No OLAP.
8. No English Query.
9. No SQL Books Online.
Some of these may not be true now but they certainly used to be...
________________________________________
From: Web Specialist [mailto:[EMAIL PROTECTED]
Sent: 13 September 2004 13:34
To: CF-Talk
Subject: Now I'm in a fix. Which DB?
Wait...wait... wait.... when MS/SQL Server Team say 25 concurrent
clients and we're running only CF to access that stored data in MSDE
DB will have only 1 client connection(CF ODBC/JDBC connection)?
Mistake?
Cheers
Richard Meredith-Hardy wrote:
>
> Max 25 it says.��With 200 - 300 intranet users I don't think this would
> be an issue, would it?���
If ColdFusion is the only client connecting to it, there won't be
more concurrent users as there are concurrent requests in the CF
administrator. IIRC that defaults to 6, so you could connect 4 CF
servers to it and still have one left for Enterprise Manager :)
Jochem
________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
