Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:85943
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain schlueters.de from 217.114.215.10 cause and error)
Message-ID: <1429869562.11703.11.camel@kuechenschabe>
To: Arvids Godjuks <arvids.godjuks@gmail.com>
Cc: Benjamin Eberlei <kontakt@beberlei.de>, PHP internals
	 <internals@lists.php.net>
Date: Fri, 24 Apr 2015 11:59:22 +0200
In-Reply-To: <CAL0xaBGV1rC1uudiMamTB6DXe9QnaCrK9Z7qee_MT2-V_iSYjw@mail.gmail.com>
References: 
	<CAMc0WS6q49-+ThWftnPwsb5ZMT_m3EVi1Eik_mO5WvtqmhBjeA@mail.gmail.com>
	 <5537826A.9010209@gmx.de>
	 <CAMc0WS4a_aqqeqHPccyFwKQYwngbP6BziqsjGzbmxQOp6sw2pg@mail.gmail.com>
	 <5538881C.8010502@oracle.com> <5538C2A7.4050600@lsces.co.uk>
	 <CAL0xaBHDZdveGO+38MqRad2eUux-k8+oAc09GjVGKWuD5QqgfQ@mail.gmail.com>
	 <5538CF4B.5090401@beccati.com> <5538D9B0.5020507@lsces.co.uk>
	 <CAL0xaBEix5PnetE-EhPVJc36SrXkH6kqi2EQXPOdnt-AsnRe_g@mail.gmail.com>
	 <CAEPJdukVGuue2JF3oWtAPWvk8AUSO8ac==LmNMSnJ6vRbBYRow@mail.gmail.com>
	 <CAL0xaBGV1rC1uudiMamTB6DXe9QnaCrK9Z7qee_MT2-V_iSYjw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Re: PDO Oracle driver
From: johannes@schlueters.de (Johannes =?ISO-8859-1?Q?Schl=FCter?=)

On Fri, 2015-04-24 at 09:16 +0300, Arvids Godjuks wrote:
> May I question the sanity of the words written in this email? :D (it's a
> joke).
> 
> The whole point of mysqlnd drivers and other improvements was to cut down
> on data copying, improving performance and doing a lot of other stuff.
> Moving PDO to a PHP implementation will kill it all: preformance will
> suffer, memory usage will skyrocket, dealing with charsets - I don't even
> wana pretend I understand how to deal with that part in a proper fasion.
> Doesn't it require access to internal PHP api's to do a lot of what PDO and
> other native drivers do?
> Well, the Zephyr could pitch in here, MAYBE, depending on how good it
> actually is and what it can do, but still, it feels more like a cruch to me.

In many many different topics I stressed that we should do things in
userland and use extensions only when needed for performance.

Doing things in userland gives
      * better debugability
      * better understanding for users
      * lower entry barrier
      * faster development time
      * better ability to evolve (different library versions can coexist
        on a system, for old and new code)

With the changes in PHP 7 this is viable for even more areas. What PDO
does is very thin. And mind: If a user truly cares about the last bit of
performance they won't use an abstraction, they use DBMS-specific SQL
and cut out abstractions. But for many cases that level of performance
matters, as usage of ORMs etc. show. Also mind that processing in the
database server and network traffic probably cost way more time than a
thin wrapper even in userspace (in real life, not in "SELECT 1")

johannes