note 44276 modified in function.ocisetprefetch by sixd
| From: | sixd@php.net | Date: | Mon, 05 Oct 2009 03:56:26 +0000 |
| Subject: | note 44276 modified in function.ocisetprefetch by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-161334@lists.php.net to get a copy of this message | ||
I noticed an amazing improvement when setting up this parameter. I was querying 300 rows, which took
3 seconds to loop through the fetches.
When I set the prefetch to 500 I could do 5000 rows in 0.7 seconds.
SQL Net protocol is horribly inefficient doing a request/confirm for each line if you don't use
this.
--was--
I noticed an amazing improvement when setting up this parameter. I was querying 300 rows, which took
3 seconds to loop through the fetches.
When I set the prefetch to 500 I could do 5000 rows in 0.7 seconds.
SQL Net protocol is horribly inefficient doing a request/confirm for each line if you don't use
this.
http://php.net/manual/en/function.ocisetprefetch.php