If you use PEAR::MDB2, you can set a custom debug handler and collect all the queries you execute for debugging and performance tunning purposes, as shown before. But what if you’re using PEAR::DB? Well, since PEAR::DB doesn’t allow you such a functionality out of the box, you can hack it a bit to get similar […]
Archive for the 'mdb2' Category
Performance tunning with PEAR::DBJan 16th, 2007
DB-2-MDB2 in PortugueseJan 16th, 2007
Through a trackback I found out that Walter Cruz has translated my DB-2-MDB2 article in a language I was led to believe is Brazilian Portuguese. the announcement the article Thanks very much Walter, this is very flattering! Thanks to my buddy Isidoro who enlightened me that the language was Portugeese!
Reusing an existing database connection with MDB2Jan 4th, 2007
This is a follow up to a question posted by Sam in my DB-2-MDB2 post. The question was if you can reuse an exisitng database connection you’ve already established and not have MDB2 creating a second connection.
Performance tuning with MDB2Dec 9th, 2006
This is a follow-up to Lars’ comment about the PEAR book. In the MDB2 chapter I showed an example how you can create custom debug handlers in MDB2 and then gave a suggestion about a useful application of this functionality for performance tuning. Basically the idea is that your custom debug handler collects all queries […]
DB-2-MDB2Feb 4th, 2006
Recently I had to move an existing project from using PEAR::DB to PEAR::MDB2 – the new database abstraction layer. I took notes on the parts of the code I needed to change, I hope they can benefit someone who’s doing the same.