RE: Slight OT : Size of MS SQLServer Databases

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 28 Jan 2002 05:19:02 -0800
Message-ID: <F001.003FCE50.20020128050024@fatcity.com>

"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: marin.dimitrov_at_sirma.bg

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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).

Received on Mon Jan 28 2002 - 07:19:02 CST