note 44276 added to function.ocisetprefetch

From: 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

« previous php.notes (#73680) next »