By al4711 on
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:
- find out the most common SQL-Statements, if not known
- 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 - 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
i agree...
i think this would be a great idea...
I myself trying to create a new db_query, that only handles bind variable queries...