Quoting Lester Caine <lester@xxxxxxxxxxx>:
I am sure if I started again now I would probably be using something other than ADOdb. But at the time it fitted the bill and where there were problems they were quickly cleared. Unlike some of the other options I tried.
May I ask which other ones you would consider ? It is becoming obvious that I will have to do some benchmarking myself. Therefore, if you had other worthy contenders to suggest (besides ADOdb and PEAR::MDB) I would probably include them in my tests.
You definitely should do your own benchmarks. Bear in mind that the ADOdb benchmarks test a certain type of behavior -- namely repeated select statements. Also bear in mind that the speeds of the different layers are going to be inversely proportional to how well they actually /abstract/ stuff. For example, ADOdb would completely fail to be portable accross databases where the case of the column names in result array changes (e.g. postgres always returns lowercase col names, Oracle always uppercase, MySQL returns mixed case, SQLite is configurable). This is one example of why some layers (like PEAR::[M]DB) may be slower.
Database abstraction is a really tricky thing. None of these layers provide 100% abstraction; that can only really be achieved with a DAO/object persistence layer (e.g. see DB_DataObject in PEAR, or Propel http://propel.phpdb.org).
I would also suggest you also add Creole (http://creole.phpdb.org) to your test list if you are considering abstraction layers for PHP5.
Cheers, Hans
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
