note 44276 added to function.ocisetprefetch
| From: | Herman at rn2 dot php dot net | Date: | Tue, 20 Jul 2004 11:01:43 +0000 |
| Subject: | note 44276 added to function.ocisetprefetch | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-73680@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.
----
Manual Page -- http://www.php.net/manual/en/function.ocisetprefetch.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+44276
Delete -- http://master.php.net/manage/user-notes.php?action=delete+44276&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+44276&report=yes
Search -- http://master.php.net/manage/user-notes.php