note 8823 deleted from ifx_do by ronabop
| From: | ronabop@php.net | Date: | Sun, 01 Oct 2000 08:27:27 +0000 |
| Subject: | note 8823 deleted from ifx_do by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-5772@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?