Use prepared statements in ubhdb
Brought to you by:
gerard
Hi,
since ubhdb uses the database a lot, ot could improve the performance if ubhdb will use prepared statements instead of $dbh->do().
As far as i understood the mysql documenatation, ->do() is a shortcut for prepare() and execute().
Prepare is quite expensive from performance point of view.
As the statements are the same during runtime (only parameter change) it could increase performance if the are prepared onde and executed many times.