I haven't run the NT version of MySQL but, in general, if the application
will almost exclusively perform read operations on the db then MySQL will be
extremely fast and should be fine. If you have a need for transactions and
stored procedures, and will perform a high number of write operations then
I'd definitely go with SQL Server. Check the MySQL and SQL Server web sites
to see exactly what features each does or does not support. MySQL has a lot
of really helpful, Internet-centric functions that are great for such
development but, SQL Server has T-SQL along with stored procedure support.
SQL Server's administrative interfaces and functionality stomp MySQL hands
down. Use of SQL Server will also allow integration of domain or AD
authentication/authorization across your application(s). If you use all 2k
products then IPSec, Kerberos, and a bunch of other security/management
capabilities are at your disposal.
That's my quick 2�
Steve
-----Original Message-----
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 19, 2000 8:06 AM
To: <[EMAIL PROTECTED]>
Subject: [CF-Talk] Performance under load - Linux vs NT
A couple of weeks back I asked on this list about how a Linux CF box
connecting to a separate Linux MySQL server would handle load.
My client's site is currently getting about 6-10 page views per second in
peak time. All images will be stored on a separate media server and I am
building the app to use static pages as much as possible.
I am now looking at the possibility of running an NT or 2000 server instead,
and using SQL server as the database. Quite simply, it is easier for me to
get good hosting support for this platform in the US (the site will be
hosted in the US, I am in Australia so support must be good).
I am looking at one or two Dual P3-700 machines with 1GB RAM and a RAID 5
system as the main CF Servers and a similar box to run the database. Will
this configuration handle the load using NT? Am I likely to see
greater/lesser performance with SQL Server vs MySQL?
Thanks for any replies.
Rob Keniger [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
