I'm sure if done right, MySQL could do whatever you want satisfactorily.
Same with MS SQL (ignoring cost).
However, something few people seem to know, but I've realized from
experience is that when you offer people services based off free
software, you get a different kind of customer. And not the good kind.
Where I work (http://www.advantcomp.com (free plug!)) we offer both
Windows and UNIX (usually OpenBSD) solutions. When people come to us
looking for something to be done in free unix (Linux, OpenBSD, PHP,
MySQL, etc), they expect to pay crappy prices. And frankly they're
crappy clients. They don't know what they want, they're only available
to talk after hours, etc. While there are a few people who are looking
for serious applications done in free software, they are few and far
between.
On the other side of the coin is people looking for "enterprise
solutions". These are people expecting to pay a lot, so they give you a
lot. These people usually look for MS SQL/ColdFusion sort of deal. The
Windows side of our company gets -WAY- more money than the free-UNIX
side.
So if you're looking to make money, and have some capital to burn to
start, I'd say use non-free software. That can be UNIX still, but not
free-unix. Sybase, DB2 or Oracle for a database, and JSP seem to be the
only "enterprise" solutions around for UNIX. But judging by your
question you don't seem to be stuck with UNIX for a platform.
If you're going NT I'd be careful with Microsoft software. IIS and MS
SQL scares the crap out of me when it comes to security.
Anywho, probably way beyond what you wanted to know,
Chris
-----Original Message-----
From: Alexander Chernienko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:51 AM
To: [EMAIL PROTECTED]
Subject: MySQL or MS SQL?
Hi all,
I'm currently writing proposals for a customer who want to hire our
little
programming team for creating corporate information system, wich
includes
huge database with number of records between 1-10 millions (incl.
blobs -
pictures). Expected database size is tens of Gb.
There is idea of using MS SQL Server for some reasons, on other hand we
have
big experience with MySQL (but with smaller databases).
So I'm very interested to hear advise, especially from people who had
experience with both SQL servers - which SQL Server is preferable in
such
situation.
In other words - huge database, blobs etc, MS SQL vs. MySQL, your
opinion?
Many thanks in advance,
Alexander
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
