I have established that the problem is not in SQLite, but has to be in
my code somewhere. I suspect it is related to the transaction/commit
problem I posted a few days ago, and I plan to track that down today
if I can. I need to finish this application by tomorrow.
2011/7/29 Martin Schreiber
Am 29.07.2011 14:32, schrieb Howard Lee Harkness:
I have established that the problem is not in SQLite, but has to be in
my code somewhere. I suspect it is related to the transaction/commit
problem I posted a few days ago, and I plan to track that down today
if I can. I need to finish this
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%'
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
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 mse00...@gmail.com wrote:
On Thursday 28 July 2011
Am 28.07.2011 21:01, schrieb 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.
I need a reproducible testcase, please send the