On 28 Feb 2014, at 9:48am, pihu...@free.fr wrote:
> I did a fourth one with a '+' sign before the "NomJob = 'NSAVBASE'" clause
> :[snip]
> This one is way quicker (0.055 second instead of 2.235 seconds in my latest
> test).
That is a good experiment. Unfortunately it depends on you knowing so
one ?
I heard indexes aren't useful for a database with a single table. What do you
suggest ?
Thanks again.
- Mail original -----
De: "Simon Slavin"
À: "General Discussion of SQLite Database"
Envoyé: Jeudi 27 Février 2014 14:08:24
Objet: Re: [sqlite] 'Select
On 26 Feb 2014, at 9:09pm, pihu...@free.fr wrote:
> Benchmark (bench.php) on the « $bdd->query(...); » instruction :
> Query 2 : select DateMonteeAuPlan, Debut, Fin, Statut from ReportJobs where
> NomJob = 'NSAVBASE' and NomChaine like 'DCLC257%' limit 20;
> => 0.0002752075195 seconde(s)
>
Hello!
I found out that some 'SELECT' SQL queries are very slow with pdo_sqlite (PHP
5.3 or PHP 5.4).
The same query entered in the sqlite3 binary is way faster.
Here is my project : http://we.tl/59fGSVnAXh (password : "sqlite-php")
- bench.php
- chaines_centre.db
- inc_func.php
- info_job.php
4 matches
Mail list logo