Catching up on my email I found a request for details about that overdue adodb-lite module for performance management. One of these days I’ll simply forget to check my email for a few months and everyone can live on in darkness and despair.

I might have peace thereafter…

Anyways, the module still progresses at a snail’s pace. As I said here on the blog before I was expecting to be taking time off PHP development (except for adodb-lite perfmon). Since my last update on the subject I have fixed a few issues I was having. I also updated the HTML output to XHTML 1.0 Transitional (complient but for 1 error). I also renamed a few function calls and standardised others. I have been testing on MySQL 4.1 and 5.0 and it seems to work just fine. I have not tested on PostgreSQL so that’s next on the agenda.

Before I continue I need to port the work to date to the newest ADOdb-Lite version which was announced with changes which may alter how its included. Not sure yet – so something for a future post. I have decided not to separate out the presentation elements. It’s too much work, and would require a fairly large overhaul – even in comparison to what I’ve adapted to date.

The only bug I know of at the moment (without intensive testing) is a failure of the SQL Log pages to run EXPLAIN commands on logger queries. It offers a blank page with a standard footer but no error message (for non-SELECT statements) or explanation for SELECTs. Probably something small that got passed over while cleaning up the class. Maybe if progress inches too slowly I’ll just make a test release in case anyone’s interested in peer review and feedback.

Related posts:

  1. ADOdb-Lite PerfMon: Basics Completed
  2. More on ADOdb-Lite and Perfmon…
  3. Another ADOdb Update
  4. Performance Monitoring for ADOdb-Lite?
  5. Escaping in ADOdb; does it exist?