note 8823 added to ifx_do

From: Date: Fri, 29 Sep 2000 09:21:30 +0000
Subject: note 8823 added to ifx_do
Groups: php.notes 
Request: Send a blank email to php-notes+get-5588@lists.php.net to get a copy of this message
ifx_prepare and ifx_do seem not to conform to the conventional Informix ESQL prepare and execute pairs, which are also found in the DBD::Informix Perl module. For example, if we want to delete a whole bunch of records, the conventional way wants to do things like this: prepare prep_curs for delete from a_table where a_id=?; for ($i=beg_id; $i<=end_id; $i++) { execute prep_curs using $i; } By doing it this way, we only prepare a statement once and reuse the return optimized query plan over and over again. So, are we going to get ifx_prepare and ifx_do functions revised? http://www.php.net/manual/function.ifx-do.php

« previous php.notes (#5588) next »