Follow Slashdot stories on Twitter

 



Forgot your password?
typodupeerror
×

Comment Re:PHP is fine (Score 2) 182

If you write a good foundation of libraries and classes you'll need a hack like APC to get any decent execution speed. It also sucks at memory utilization. Everyone likes to link to that "fractal of bad design" article, but it's pretty much just a bunch of whining. Here's a real article that just plain hurts, it has to do with PHP's memory allocation: https://nikic.github.io/2011/1...

Comment Process management, PG versus Mysql (Score 1) 320

One thing very relevant for discussion, that I didn't see mentioned here, is how connections are handled across the different RDBMS. PG still uses one process per connection. This can make its memory utilization grow substantially under high connection counts. Oracle and Mysql don't suffer from this issue.

Comment Re:I choose MS SQL Server (Score 2) 320

Just the wording "a DB license" leads me to believe your exposure is with smaller companies and smaller datasets. Have you ever priced a single 32 core Oracle installation with the data warehousing option enabled? If it's a business of any size, you'll need to cluster for reliability, so multiply that single license out. And if it's a publicly traded company, you'll probably need an offsite standby cluster. Even though it sits there and does nothing 24/7, the licensing fee for the standby cluster will be the exact same price as if it was the primary. Also, don't forget dev and testing environments, those aren't free.

Not every large company is a high-margin high tech company. The retail sector, for example, has mountains of data and relatively low margins. DB license expense can be a big concern.

Comment Re:Doesn't PostgreSQL have transactional metadata? (Score 1) 320

Can you read? I said "the ease in application of DDL changes", not that the application was applying DDL. In other words, when our DBA applied changes under Oracle, packages would be invalidated and all users had to exit the application. This issue doesn't exist under PG. You're an idiot, BTW.

Comment Re:I choose MS SQL Server (Score 3, Insightful) 320

It's not cheap at all once you get into even just medium-scale usage. If you have a situation where you are starting out small but plan to grow, you need to really consider whether it's wise to go with a commercial RDMBS, because the pricing does get nasty when you get to the point of needing clusters, high core counts, and standby sites.

Slashdot Top Deals

Always draw your curves, then plot your reading.

Working...