Menu

#63 Use prepared statements in ubhdb

open
nobody
None
5
2007-10-22
2007-10-22
Anonymous
No

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.

Discussion


Log in to post a comment.

MongoDB Logo MongoDB