Catch up on stories from the past week (and beyond) at the Slashdot story archive

 



Forgot your password?
typodupeerror

Comment: Re:PHP is fine (Score 2) 182

by bad-badtz-maru (#49323553) Attached to: Modern PHP: New Features and Good Practices

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

by bad-badtz-maru (#49301621) Attached to: Why I Choose PostgreSQL Over MySQL/MariaDB

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

by bad-badtz-maru (#49301207) Attached to: Why I Choose PostgreSQL Over MySQL/MariaDB

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

by bad-badtz-maru (#49300723) Attached to: Why I Choose PostgreSQL Over MySQL/MariaDB

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

by bad-badtz-maru (#49294965) Attached to: Why I Choose PostgreSQL Over MySQL/MariaDB

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.

You cannot have a science without measurement. -- R. W. Hamming

Working...