….mysql-query.php. Unfortunately there is nothing interesting for our current task excluding link to mysql_unbuffered_query and this link says: mysql_unbuffered_query() sends a SQL query query to MySQL, without fetching and buffering the result rows automatically, as mysql_query() does. So mysql_query…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… 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… to check if there are any errors while fetching. With mysql_unbuffered_query data comes in portions so you can well get an…
Comment: Handling big result sets
June 27, 2006 By 13 Comments
… the following results: mysql_query: Number of rows: 1000000. execution time: 24.53382897377 s mysql_unbuffered_query: (same code, only changing mysql_query to mysql_unbuffered_query) Number of rows… my table (InnoDB) has 10+ million records in there. The query I used: SELECT * FROM `current` LIMIT 1000000; I had to…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… be reflective to large full table scan and index scan queries, though this is really not the point. The point is… untapped potential in MySQL IO as I think we should be getting very close numbers for buffered and unbuffered IO for read… anything unbuffered performance should be better as it has less overhead with double buffering as well as more information MySQL has about…
