rhi said:
Joey, the religous statement was an analogy. I don't think he's turning this into a religous war.
it kinda is.
rhi said:
All database/BI storage & performance statistics are monitored daily via scripts & programs and are automatically emailed to me 1st thing every morning. This problem occurred due to a faulty patch, as I mentioned, and grew the file 2 gig within a couple of hours, resulting in the crash that I mentioned. Your mention of "enablelargefiles" suggests that I should have done this, added a whole bunch of extents, and made the database sooooo big that it can accomodate such unreasonable growth, and thereby avoiding the crash. I have news for you - that is not the way to manage a database, and anyone who does that should be fired. The proper way is to monitor daily, as I do, and when a problem occurs, hope that you are running on a QUALITY database platform such as Oracle, that will allow the DBA to rectify the problem without interrupting daily business transactions.
wow, i've never seen a progress database so heavily monitored. make sense to use fathom, monitor trends, warnings, alerts etc. thru the web. there was talk for a while that fathom would replace explorer but that didn't go thru.
unlike oracle it doesn't install with a dba. full time progress dba's are pretty rare. i know of a case where the server was dry walled over because no one had to actually go there.
rhi said:
Try telling any IT director in charge of mission critical apps, which need to be running 24/7, that database features are not important, especially when those features can avoid database crashes, which cost companies money.
that's what i'm talking about. you could make a point if you'd argue a business point. not copy pasting the features from a brochure. and that's how you have to look at it. it was designed and shaped for certain business uses, not for going after oracle.
rhi said:
Besides, there are many levels at which Progress can not compete with Oracle, such as performance.
what is this major performance handicap you keep mentioning. you should be able to scratch the 100,000 lines per second queries even with modest hardware configurations. as a rule of thumb i would never accept any report/query running over a couple or so minutes.
you're not really using remote connections are you ? it's also pretty simple for a developer to screw up an application regardless of the database.
rhi said:
Wrong again. The progress client is sold & licensed seperately from the database. You can run Progress 4gl against Oracle or SQL Server - both of which are much better databases than Progress.
now you're reaching. i doubt the database is bought to be used by some thing other then 4gl/abl, pretty rare. it's still mostly used for some level of interoperability. progress is a development platform etc. not only a database.
wow, i've got tons of horror stories about sql server, crashes, page/block level locks ?! and so on. funny a friend of mine works at microsoft, though he's a linux guy at heart.
but why would anyone use any other database other then oracle. maybe not every shop needs or can afford these enterprise level features.
rhi said:
Using a Progress database is like driving a stick-shift car in handcuffs. It can be done, but at some point you are probably going to crash because you don't have much control.
here's another one, "ak-47 vs m-16"
none of this space age materials, just rrrrrrussian steel and wood. it may not be as accurate or lightweight. but it doesn't need to be constantly cleaned and won't jam on you either. you can throw it in the mud swim with it and it'll keep kicking ***, arrrrrrr
you can count on both hands every time i've ever had a progress database crash on me, and none of them had a full time dba. one was due to the cleaning lady getting adventures and most others are os and hardware related. i've got a few crazy stories
but hey, like i've said before if you're looking for a serious discussion with java, .net, oracle and other database professionals, contractors, ap's, progress executives, academias etc. go to PEG !
i haven't even graduated yet. but i'm not exactly a college kid either, i've served for few years prior to entering university, unlike rambo over here.