… mysql_query uses mysql_store_result C library call and buffers all result set in…mysqli and PDO have their own way to reach similar behavior. This call users underlying mysql_use_result API call which does not store all result…efficient especially when multiple servers are involved and you want to do…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go for using mysqli…to use query and external caching of result sets is generally a good idea and having pre-compiled summary data ready to…
Comment: Handling big result sets
July 5, 2006 By 13 Comments
… runs: Initial Time: 73.3s Unbuffered: 59.3s Using MySQLi: 39.46 MySQLi w/o store_result(): 26.44 So it would seem that your… more congested network there would be a point when buffering would provide some benefit? Thanks for taking the time to investigate this.
