| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slight OT : Size of MS SQLServer Databases
Mark,
Thank you very much for you help.
Regards,
Antonio Belloni
"Mark Leith"
<mark_at_cool-to To: Multiple recipients of list ORACLE-L
ols.co.uk> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity. Subject: RE: Slight OT : Size of MS
SQLServer
com Databases
28/01/02
13:40
Please
respond to
ORACLE-L
Hi Antonio
If the database is only 20-30 gig, then I don't think that you'll have any problems with SQLServer managing this - it's not "large" in real terms.
If you already know Oracle then (IMHO) the learning curve for SQLServer
will
be fairly easy going (I've trained on both in this order too, and found it
*very* easy to pick up). This is not to say that there won't be an outlay
for training though..
You can connect an apache server to a SQLServer database (AH HA! This is
freeware though ;P Even though it's bundled with Oracle..). You can't
program with VBScript if you don't use IIS, but you aren't using this on
your Oracle side of things, and it probably adds more to the learning
curve.. Database connectivity to a SQLServer database through Apache is
handled with the Perl DBI module, and the relevant DBD:: module. Note that
DBD::Sybase is probably the way to go to get to SQLServer. They both share
a common code base, and the Sybase driver is reputed to work better than
the
SQLServer one.
Check out:
http://www.apache-asp.org/faq.html#How%20is%20databc9095df5
You can also use Tomcat as well AFAIK, and it most probably sets up in the same way as Apache.
I'd still push to go with MySQL though personally, it performs better, it's free, and you can run it on a LINUX server with Apache and the Perl DBD::MySQL module just as easily..
Just my Ģ0.02 - but hey, what do I know! ;P
HTH Mark
-----Original Message-----
antonio.belloni_at_hstern.com.br
Sent: 28 January 2002 15:30
To: Multiple recipients of list ORACLE-L
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_at_cool-to To: Multiple recipients of
list
ols.co.uk> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_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
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: antonio.belloni_at_hstern.com.br 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: antonio.belloni_at_hstern.com.br 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 - 11:50:38 CST
 |
 |