Re: Informix limitations, should we be using Oracle?

Well, what can I say??? Didn't mean to start WWIII guys! First of, thanks to Daniel for posting the only useful response. To the others, I can assure you that I don't work for Oracle or any marketing company or whatever. I've picked up a large DW project that has been mangled in the past and I'm trying to find out some of the root causes. Of course I'm going to IBM as well to get their feedback but as I've had some good help from this group before, I thought that maybe someone would have some relevant experience or could help to set me and the team here straight.

We've tried to get some experienced resource in to help us out but out here in Australia there are no appropriate skills. None. We've tried. It's a last gasp for us... I'd love to get the thing working as it's intended but at most we've been able to read the manual, make observations on performance and draw our own conclusions - which from the feedback, seem to be fundamentally wrong. No-one has pointed out why, but not to worry, we'll keep trying.

Oh, completely agree about the 'why are you running XPS on one node?' comments. That is what we inherited and we don't understand either... if someone could give me the $$$ then I'd go out and buy more servers etc. but that ain't going to happen in a hurry.

Our feeling at the moment is that we need a db for which there are DBA skills available on the open market in our country. At the moment, we can't see what's going on in XPS and we can't see that changing...

Sorry to waste anyone's time and feel free to ignore the thread!

Cheers,
Simon.

(Oh, and yes, of course it is a star schema...) Received on Thu Oct 17 2002 - 03:52:55 CEST