Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:111706
To: Matteo Beccati <php@beccati.com>, Gabriel Caruso <carusogabriel@php.net>
Cc: "G. P. B." <george.banyard@gmail.com>,
 =?UTF-8?Q?Dino_Pejakovi=c4=87?= <dino.pejakovic@voxdiversa.hr>,
 PHP internals <internals@lists.php.net>, Derick Rethans <derick@php.net>,
 Sara Golemon <pollita@php.net>
References: <08b959f5-7652-5e8a-562a-c2659facec8c@voxdiversa.hr>
 <c2e43e61-bc14-2b0f-6fdd-28235153ced8@beccati.com>
 <CAFPFaMJTErRzCuA5RWAsfPmqUr9Hx22+4RuCH9NKKioVgf+3OA@mail.gmail.com>
 <20277058-b463-038a-4333-eacd023ccdc4@beccati.com>
 <3220cfac-aeca-0e28-3574-77e2b2c89b1d@beccati.com>
 <CAP=4hC+FLR9rS9R_NP8hvMPNjPrttJPD99g2Jd90BA7dYdk3aQ@mail.gmail.com>
 <89a30aeb-0892-6b9a-03c3-72bc6154eda3@beccati.com>
Message-ID: <a784646b-a711-508f-718f-8a4c0bef6138@gmx.de>
Date: Fri, 28 Aug 2020 22:57:40 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101
 Thunderbird/68.12.0
MIME-Version: 1.0
In-Reply-To: <89a30aeb-0892-6b9a-03c3-72bc6154eda3@beccati.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] PDO fetch performance problems with many bindparameters
From: cmbecker69@gmx.de ("Christoph M. Becker")

On 28.08.2020 at 20:36, Matteo Beccati wrote:

> Hi Gabriel,
>
>> Let's have this patch merged into PHP 8.0 (`master` branch as of today)=
, I
>> have nothing against it.>
>> About PHPs 7.3 and 7.4: if the performance improvements are this massiv=
e as
>> describe in this email, I'm :+1: to have it on those versions as well.
>
> The mileage may very: running the Doctrine test suite, for example,
> shows no difference at all.
>
> On the other side of the spectrum, a SELECT * FROM tbl WHERE id IN (?,
> ....) and 65535 parameters:
>
> https://gist.github.com/mbeccati/6f2cd094c38b094cb4bfc4c0245a23ab
>
> root@jameson /tmp # /tmp/php-7.4-std bench_pdo3.php
> Got rows: 65535
> [Timings] prep: 0.018, exec: 0.210, fetch: 35.812
>
> root@jameson /tmp # /tmp/php-7.4-opt bench_pdo3.php
> Got rows: 65535
> [Timings] prep: 0.019, exec: 0.208, fetch: 0.026
>
> That's almost 36 seconds vs 26ms.

Can we be certain that the relevant bits of the formerly _reserved_flags
are zero-filled for all existing drivers?

=2D-
Christoph M. Becker