Re: [sqlite] System.Data.SQLite - issues

[Joe Mistachkin]

Chris Abbott wrote:
> 
> I've also noticed a drastic degradation in speed with this release over 
> 1.0.86. 
>

This issue should be fixed in 1.0.94.0.  Please try with the pre-release
bits available at:


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

--
Joe Mistachkin

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

Re: [sqlite] System.Data.SQLite - issues

[Chris Abbott]

  writes:

> 
> Hi,
> Below are the two issues I would like to report for SQLite .Net client.
> 1. SQLiteDataReader.GetString() method:
> The method fails with "Invalid cast exception" when you try to retrieve a 
number stored in a text field.
> 
> 2. SQLiteDataReader.GetValue performance in version 1.0.93:
> This method is considerably slower in this version. While benchmarking, the 
fetch was about 7-8 times
> slower. First I thought it was the NGQP (since I upgraded from version 3.7 
to 3.8.5), but while trying to
> break it down, it appeared the issue was with this fetch method.
> 
> Thanks,
> Manish Kukreti 
> 

Platform: VS2010, .NET 4 target platform.

I've also noticed a drastic degradation in speed with this release over 
1.0.86. We have a mobile device detection system which runs detections mostly 
from cache, but also from an SQLite memory instance. A single-thread batch job 
over 100,000 user-agents goes from average 130 seconds to over 250 with this 
update, which is a horrific decrease in speed. It's a bad enough effect to 
necessitate a downgrade.

Chris

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

Re: [sqlite] System.Data.SQLite - issues

[Joe Mistachkin]

Manish Kukreti wrote:
> 
> 1. SQLiteDataReader.GetString() method:
> The method fails with "Invalid cast exception" when you try to retrieve
> a number stored in a text field.
> 

Do you have some example C# code and/or a database schema that demonstrates
this issue?  What is the declared data type of the column value being
fetched
when the exception is being thrown?

> 
> 2. SQLiteDataReader.GetValue performance in version 1.0.93:
> This method is considerably slower in this version. While benchmarking,
the
> fetch was about 7-8 times slower. First I thought it was the NGQP (since I
> upgraded from version 3.7 to 3.8.5), but while trying to break it down, it
> appeared the issue was with this fetch method.
> 

Slower for what types of values?  This is another issue where the database
schema and possibly some C# code demonstrating the problem would be quite
valuable.

--
Joe Mistachkin

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