…mysql_real_query / mysql_use_result or mysql_store_result, which are the same). mysqli_query with MYSQLI_STORE_RESULT (used by default) is equal mysql_query, and with MYSQLI_USE_RESULT – is equal to mysql_unbuffered_query. Results: MYSQLI_STORE_RESULT…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…via PHP memory management which does not apply to MySQL result set. OK there is “easy” fix for this problem, you can use mysql_unbuffered_query instead and mysqli and PDO have their own way to reach similar behavior. This call users underlying mysql_use_result API call…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, …just few queries concurrently. If you have these queries doing large sorts, using temporary tables…configuration. Thousands of concurrent connections usually result from cases when there are many…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go for using mysqli…common. > I would also note for many PHP applications abstraction layer is > not the main … – yes – I agree. Learning to use query and external caching of result sets is generally a good…
