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

[Martin Schreiber]

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