Hi Mark,
It will be a tipically B2C site. We estimate the size on 20-30 Gb and
number of concurrent users depends of the sucess of the site.
>From all the companies that we have contact and are using SQLServer , the
biggest production database was 8 Gb. Being an Oracle shop and considering
the costs of training/implementation/installation we think that it is our
best option in the commercial databases arena. Management is only
considering the price to buy a new software/a new Oracle license. That�s
why we are so worried about adopting SQLServer to this project and we want
stress all the possibilities and see if it�s able to scale if the
database/application grows fast.
Another concerning is about the application server. SQLServer will run only
in winNT/2000/XPpro. Will we be able to run a different application server
than IIS and connect to the database ?
Thanks for your help,
Antonio Belloni
PS.: We are big fans of free software and known the potential of the
architecture, but it�s totally out of question in this shop. Kind of "Free
software here ?! No way !!!! It�s serve only nerds and hackers
purposes...". Management......tsk,tsk,tsk.
"Mark Leith"
<mark@cool-to To: Multiple recipients of list ORACLE-L
ols.co.uk> <[EMAIL PROTECTED]>
Sent by: cc:
root@fatcity. Subject: RE: Slight OT : Size of MS
SQLServer
com Databases
28/01/02
10:00
Please
respond to
ORACLE-L
"if u consider SAP DB then u may take a look at
http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm
which contains some outdated benchmarks for SAP R/3 running on different
databases and u'll see that SAP DB outperforms MS SQL in some
configurations"
I think that Antonio was actually trying to *SAVE* money - not spend *more*
;)
Another option to look at (and very popular for web backend databases and
is
*free*) is MySQL. I am currently working on a project for our web site that
involves MySQL with PHP, and Perl with the DBD::MySQL module, and have to
say for *our* needs this set up seems like it is more than enough..
I guess the ultimate question to ask (and I haven't seen this yet) is how
big do you want the database to be? What is the projected size of this
database? How many concurrent users do your foresee having? There has been
talk of SQLServer taking up to a terabyte of data, spread across a
clustered
Win2K environment (no I have no link, or reference, but can remember this
posted on a web site *somewhere* out there). But this means spending
BIG-TIME just on the kit to host it..
What do you *need* to achieve?
Mark
-----Original Message-----
Dimitrov
Sent: 28 January 2002 11:45
To: Multiple recipients of list ORACLE-L
>
> Please , correct me if I am wrong , but as far as I know , Personal
Oracle
> is single-user. It�s intend to be a desktop database.
>
maybe u could consider some free databases?
of course the performance, functionality and the ease of use won't be
comparable to MS SQL but many sites use such databases quite successfully
if u consider Postgres SQL and take a look at
http://www.pgsql.com/user_gallery/ u'll see production databases ranging
from 10GB to 150GB
if u consider SAP DB then u may take a look at
http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm
which contains some outdated benchmarks for SAP R/3 running on different
databases and u'll see that SAP DB outperforms MS SQL in some
configurations
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marin Dimitrov
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
