ID: 37912
User updated by: dangerousdave86 at hotmail dot com
Reported By: dangerousdave86 at hotmail dot com
Status: Bogus
Bug Type: SQLite related
Operating System: Windows XP SP2 + Apache 2
PHP Version: 5.1.4
New Comment:
Is there anyway to request an update, or is it definatly wait and see.
Previous Comments:
------------------------------------------------------------------------
[2006-06-26 16:19:59] [EMAIL PROTECTED]
Actually, it's 3.2.8 (which is 6 months old) in 5_2 branch and you can
always use external SQLite library with PHP (though, not on windows
apparently).
I'm sure we'll update SQLite soon to the latest version, but I don't
think anybody can help you until then.
Anyway, it's not PHP problem -> "bogus".
------------------------------------------------------------------------
[2006-06-26 16:11:40] dangerousdave86 at hotmail dot com
SQLite is currently on version 3.3.6, while PHP appears to be using
3.2.5, being 11 releases old this could well be the real issue.
------------------------------------------------------------------------
[2006-06-26 16:08:16] [EMAIL PROTECTED]
>I've traced the problem to the 'GROUP BY' clause in the query.
Doesn't look like something related to PHP, but likely to be SQLite
problem.
------------------------------------------------------------------------
[2006-06-26 15:58:32] dangerousdave86 at hotmail dot com
I cant really give example code as it would require a database or a
large amount of code to create one.
I've traced the problem to the 'GROUP BY' clause in the query. Without
it the slow query executes equally as fast as the first.
I think the problem probably lies within SQLite and not PHP. An updated
SQLite client library would probably do for seeing if this is the case.
------------------------------------------------------------------------
[2006-06-26 07:18:59] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37912
--
Edit this bug report at http://bugs.php.net/?id=37912&edit=1
