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@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus