There’s a company I work with (read, “for”) that seems to be having a bit of trouble getting 4M rows into a table. Typically this isn’t an issue, but the nature of the data, suggests Oracle support, is causing the index to be “unbalanced.” There’s a more technical term for the lack of […]

I got a call from Chris Jones over at Oracle about some really cool news. Oracle 11g’s support for Database Resident Connection Pooling (pdf) is now supported in the beta version of PHP’s OCI8 Driver. Chris and I had a long conversation a couple weeks back about where the responsibility for the driver […]

This is one of the coolest things ever. One of our wonderfully spectacular DBAs (Hi, Brian!) pointed this out and it has saved us a couple times. I know there are better ways to implement this specific example, but it’s to illustrate a point. Here’s what we do now:
CREATE TABLE temp_1 (
user_id […]

Matthew Turland wrote on his blog, “[the nested set] model is simple and intuitive, but it has a drawback: to obtain any significant portion of the hierarchy stored in a table can take up to as many queries as there are levels of depth in the hierarchy.” I like the theory that Matthew talks […]