[Lazarus] SQLite performance problem. Simple query takes too long.

[Howard Lee Harkness]

Unfortunately, it has a lot of information that is sensitive (belongs
to a client). I will look at building a database with dummy data. I
can, however, provide the schema, if that would help.

On Thu, Jul 28, 2011 at 2:10 PM, Martin Schreiber <mse00000 at gmail.com> wrote:
> On Thursday 28 July 2011 17:54:03 Howard Lee Harkness wrote:
>> I am doing a conversion of a small database application from
>> PostgreSQL to SQLite.
>>
>> I have gotten the program to work, but it it about 2 orders of
>> magnitude slower than the PostgreSQL version. In particular, a query
>> like
>>
>>     select distinct clients.* from clients where  lastname like
>> 'Hark%' order by lastname, firstname, middlename;
>>
> Can you post the database file at a place where I can download it or send it
> to my Email address if it is not too big?
>
> Martin
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>



-- 
Howard Lee Harkness
(214) 390-4896