Hi,

have anybody looked into the possibility to add mysqli_stmt_prepare (http://www.php.net/manual/en/function.mysqli-stmt-prepare.php) into the includes/database.mysqli.inc?

How about to go this way:

  1. find out the most common SQL-Statements, if not known
  2. make a hash with this statements, in a early state, which are prepared with the prepare statement, this could be done also for some other dbs
  3. in the _db_query() first look if you find a prepared statement if not go as before, if yes then use the prepared statement with the given paramters

I think this will be speed up some of the heavy queries.
I will look deeper if there is interest into this issue.

Comments

crosenblum’s picture

i think this would be a great idea...

I myself trying to create a new db_query, that only handles bind variable queries...