Remix.run Logo
SlightlyLeftPad 3 days ago

If you want to build a system of monolith services and be locked into a 30 year old waterfall development model, then Oracle is for you.

I’ve had this argument with several DBAs. They always claim “Oracle is the most performant,” while quite possibly true technically, they also tend to run a single massive instance that inevitably leads to a complete failure of the site under heavy load. Oracle is often designed to be the single point of failure. I believe that is by design. The same problems can be solved with modern event driven architectures, better caching, horizontal dynamic scaling, etc.

exidy 3 days ago | parent | next [-]

I had to explain this to some slightly younger colleagues recently. It's hard to believe now, but in ye olde days hardware was not as cheap and abundant as it is now. So you invested heavily in your database servers and to justify the hardware and software cost, ran as many workloads as possible on it to spread the pain.

This is also the same incentives that resulted in many classic architectures from 80s and 90s relying heavily on stored procedures. It was the only place where certain data could be crunched in a performant way. Middleware servers lacked the CPU and memory to crunch large datasets, and the network was more of a performance bottleneck.

nocommandline 3 days ago | parent | prev [-]

> and be locked into a 30 year old waterfall development model,

Oracle switched from Waterfall development model to sprint years ago. They also switched from yearly to quarterly releases (for their Apps) which means they deliver a lot of features in a year.

kstrauser 3 days ago | parent [-]

> They also switched from yearly to quarterly releases (for their Apps) which means they deliver a lot of features in a year.

Without commenting on whether this is true of Oracle, that conclusion doesn't inherently follow from the given. If I'm driving 60 miles per hour, then recalculate it in miles per minute, that doesn't actually mean I'm going faster. Oracle could easily be delivering 1/8 a year's worth of features in 1/4 a year due to release process overhead for all I'd know.