Re: Questions before purchasing Informix

--- Chris Moehring <chris.moehring@txucom.com> wrote: > I am considering purchasing Informix's IDS rather > than Oracle's 8. > > I have heard that I guess you might have spoken to some big O flavoured guy. I am working with Informix IDS, XPS and Oracle 8.0.5.1 Let me answer your questions > 1) Informix was faster than Oracle but much harder > to maintain. Informix is the easiest one to maintain. I was working one time with Oracle DBA. He need to kill just one session for one particular user. That user was running 15 sessions. You know how much time it took for him to kill that session, 45 min. In informix it takes 1 min. Anyway, do you know that how many V$,X$,DBA tables, USER tables, ALL tables you have to play in ORacle to maintain the system???? In informix it just onstat magic gives you every thing. Informix utilities are great like onparams, onlog, ontape, onbar, ISM and all onstat options. > 2) Harder to get support for Informix. People don't > want to mess with > it. I am using Informix from last 6 Yrs. I always get a tech support engineer to work with in a resonable time. Try with Oracle tech support and then let me know. > 3) Stored procedures have to be done one line at a > time with > Informix....very > time consuming. I guess that Art S. Kagel told one time that Informix architechted in this way. Stored procrdures are not supposed to write utilities but normal sql. If you need to write utilities, use I4GL or Dyanmic 4GL or ESQLC. > I am please with the speed but the last thing that > we need right now is > server/software taking up our time to maintain. Maintenance!!!Informix architecture is really great. It's the easiest i have seen to work with. IDS really give you better control on MEMORY, CPU allocation to Informix b'coz of it's memory and vp architecture. Also it's optimizer and table fragmentation are great to work with. > Can anyone address the validity of these statements? I can only say that you need to talk to right people and evaluate yourself. > Thanks, > Chris > > Sanjeev K. Sagar _________________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com