> Hi, Stephane,
> actually we have the database running on Sybase but there it is way too
> slow ( as I
> told everyone here before). The application has about 25 small and about
> 10 large
> tables. Data comes in every night about 100-250MB. We have just about 20
> users
> doing 'ad hoc' queries to the database via a commercial tool. At the
> moment we
> have a test installation running on an IBM computer having 2 processors a
> 2Ghz, 2
> Gig RAM. Some typical queries involove joing 2 tables each holding
> 2Million rows.
> Test situation will represent data warehouse after being 3 years in
> production.
> Well, now the query takes about 15-20 Mintues which is too slow for our
> sales
> people. I calculated, the machine scans about 800000-1Mio rows per second.
> I thought, there are a lot of tuning possibilites in Oracle that are not
> available in
> Sybase. Our system can run on both RDBMS. So as we are buying a new
> machine
> for our database test environment I thought I better find out which is
> best equipment
> for Oracle as I expect people to learn that Sybase is not your number one
> when you
> go for a fdata warehouse. Overall we calculated, that we add new muodules
> over
> next couple of years so finally DW will hold 20 Gig data.
> Windows is chosen as sales folk here says Windows machines are a lot
> cheaper
> than UNIX and the commercial tool needs some server processes available
> not for
> Linux....
> Any further recommendations?
> Regards,
> Antje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
INET: Antje.Sackwitz_at_ppi.de
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 Fri Aug 16 2002 - 02:43:18 CDT
