http://www.openclosure.org Wed, 06 Aug 2008 20:55:20 +0000 http://backend.userland.com/rss092 en 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 ... http://www.openclosure.org/2008/08/05/oracle-partitioned-indexes-part-1-identifying-the-need/ 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 ... http://www.openclosure.org/2007/10/19/php-oci8-driver-update/ 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 ... http://www.openclosure.org/2007/10/18/oracle-with-clause/ 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 ... http://www.openclosure.org/2007/10/15/hierarchical-data-sets/