Re: [sqlite] System.Data.Sqlite.dll v93 performance issues...

[Joe Mistachkin]

Andreas Hofmann wrote:
>
> 2)  Where can I create a bug for this? 
> 

These issues should be fixed in the pre-release 1.0.94.0 build, available
from here:

https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki

Please let us know if this solves the issue in your environment.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.Sqlite.dll v93 performance issues...

[Andreas Hofmann]

Guys,

 

I do not know if this is the right forum, but we found a reproducible perf
issue with System.Data.Sqlite.dll. A simple query like this:

 

Select * from Dxlog  where  ContestNR = 0  order by contestnr, TS   limit 24
offset 143098

 

Takes about 60ms to fetch the first record from the reader, and then only
0.5ms for the rest of the 24 rows.  When I go back to version 92, it takes
only 2ms for the first fetch.

 

I can provivide more details if needed, but for now, I need to know these
two things:

1)  Where can I find the older builds, especially the statically linked
one for v92.

2)  Where can I create a bug for this?

 

Thanks

Andy

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users