> 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: [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).
