…Could not select database’); $time_start = microtime(true); // Performing SQL query $query = ‘SELECT * FROM longf’; $result =…< ?php $mysqli = new mysqli(“localhost”, “root”, “”, “test”); /* check connection */ if (mysqli_connect_errno()) { printf(“Connect failed: %s\n”, mysqli_connect_error()); exit…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… and will perform needed checks and query rewriting. You also can use pretty much direct path to mysqli extension to performance critical queries… for many PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections can be much more… well as much more queries per page which will make performance improvement much smaller. Notable exception being AJAX applications which may…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… > and will perform needed checks and query rewriting. You also can > use pretty much direct path to mysqli extension to performance > critical queries… well as much more queries per page which will make > performance improvement much smaller. Notable exception being > AJAX applications which may…
Comment: Why MySQL could be slow with large tables ?
November 21, 2009 By 141 Comments
… is becoming a problem. My original insert script used a mysqli prepared statement to insert each row as we iterate through… insert 50 records at a time. There is no appreciable performance gain. I know I will most likely have to break… plan of attack should be to get the best insert performance? MERGE tables? PARTITION tables? Simply break up my big table…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of the reasons some people… so they should not handle keep alive serve images or perform spoon feeding. You can place squid in front, use apache… Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor performance that was not the…
Comment: Are PHP persistent connections evil ?
January 12, 2008 By 32 Comments
[...] mysqli pour des problèmes de performances et de stabilité (voir ce post très intéressant : http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/). Apparemment, ces problèmes ont été résolus avec mysqlnd puisque cette fonctionnalité [...]
Comment: Are PHP persistent connections evil ?
December 4, 2007 By 32 Comments
[...] mysqli pour des problèmes de performances et de stabilité (voir ce post très intéressant : http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/). Apparemment, ces problèmes ont été résolus avec mysqlnd puisque cette fonctionnalité [...]
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
… deadlocks you may serialize your transactions, it will show poor performance of course but this is other story. No there is… you’re using or even for example in php extend mysqli class so it masks such errors for you by retrying…
Comment: Are PHP persistent connections evil ?
November 14, 2006 By 32 Comments
[...] At the MySQL Performance Blog there is a very interesting article about PHP’s persistent MySQL connections and why there are not enabled by default in the mysqli extension. [...]
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… as well. As you probably know I care more about performance than about portability – for my application chance of going from… tons of thing manually. You can create a child from mysqli class and extend it with tons of custom behavior but…
