Edit report at https://bugs.php.net/bug.php?id=64475&edit=1
ID: 64475
Comment by: pawlaktomek at gmail dot com
Reported by: alejosimon at gmail dot com
Summary: Update the version of internal SQLite lib in windows
builds
Status: Open
Type: Feature/Change Request
Package: PDO related
Operating System: Windows 7
PHP Version: 5.5.0alpha5
Block user comment: N
Private report: N
New Comment:
Please also update SQLite in all currently supported branches of PHP (e.g. 5.3
and
5.4).
This is important to me, because SQLite 3.3.15+ far more effectively handles IN
operator in WHERE clause, than it was in
previous releases. Consequently change of SQLite engine version from 3.7.7.1 to
3.3.15 causes queries in my application running
3-5 times faster.
Previous Comments:
------------------------------------------------------------------------
[2013-03-21 12:16:50] alejosimon at gmail dot com
Description:
------------
You can update the version of sqlite in this new version of PHP?
...because in unix systems use a global scope sqlite lib... but in windows
systems
depend only of the internal version from the php build, and still is 3.7.7.1
from
php 5.4/5
... and php 5.5 should come with the new sqlite version, you think? :-)
... or remember the pdo_sqlite_external.dll ????? this was a good solution but
died! :-(
Thanks!
Test script:
---------------
<?php
$pdo = new PDO( 'sqlite::memory:' ) ;
$res = $pdo->query( 'SELECT sqlite_version()' ) ;
print_r( $res->fetchColumn() ) ;
?>
Expected result:
----------------
3.7.16
Actual result:
--------------
3.7.7.1
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=64475&edit=1
