SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Marc Giao on October 18, 2011, 05:17:46 PM

Title: SQLite3 dll speed issue...
Post by: Marc Giao on October 18, 2011, 05:17:46 PM
Hi All,

First and foremost, Fred, thank you for the latest release and all your effort.

Now for my puzzle, I
Title: Re: SQLite3 dll speed issue...
Post by: Sean Roe on October 18, 2011, 08:43:41 PM
Been following an issue over on the SQLite forums through email and there was someone else mentioning about a speed problem and that you should go hear for the answer: http://www.sqlite.org/src/ci/27c65d4d9c?sbs=0

And that upgrading to 3.7.8 will fix it.

Here is part of the email i received:

Quote
>
> Likely you are hitting a problem causing SQLite to create an automatic
> index for this type of query. Fixed here:
>
>  http://www.sqlite.org/src/ci/**27c65d4d9c?sbs=0<http://www.sqlite.org/src/ci/27c65d4d9c?sbs=0>
>
> Updating to 3.7.8 should fix it.
>
>
That's it!, I've set
PRAGMA automatic_index = false;
and it's back to normal speed.

Seems a very long hold up just for creating an index though - It's a very
small table really, < 100 rows.

Anyway happy enough with a workaround for now, appreciate your help.

Cheers,
Owen.
Title: Re: SQLite3 dll speed issue...
Post by: Fred Meier on October 18, 2011, 09:18:11 PM
I have not noticed any problem with 3.7.7.1.  Keep us posted if 3.7.8 fixes problem.
Title: Re: SQLite3 dll speed issue...
Post by: Marc Giao on October 18, 2011, 11:48:35 PM
Hi Sean,

Thanks for the pointer, I am happy to report 3.7.8 does indeed fix the problem! I haven't tried using "PRAGMA automatic_index = false" with earlier versions to see if it also resolves the problem.

I can't say I understand what's happening/going on but 3.7.8 does resolves the speed issue.

Thanks for the help Sean and Fred for a great product... isn't this forum great?!?!

Best Regards,

Marc
Title: Re: SQLite3 dll speed issue...
Post by: Marc Giao on October 19, 2011, 12:17:33 PM
And using:

slEXE( "PRAGMA automatic_index = false", "E" )

Resolves the issue with version 3.7.7.1! However, 3.7.8 still seems to be faster to me, athough 3.7.8's faster speed versus 3.7.7.1 is strictly based on observation and not on hard testing.

Best Regards,

Marc
Title: Re: SQLite3 dll speed issue...
Post by: D. Wilson on October 21, 2011, 12:41:27 AM
How / Where do I get the updated DLL ??
Title: Re: SQLite3 dll speed issue...
Post by: Marc Giao on October 21, 2011, 01:14:14 AM
Easy :)

The second download under "Precompiled Binaries For Windows" in the following link:

http://www.sqlite.org/download.html (http://www.sqlite.org/download.html)

Marc
Title: Re: SQLite3 dll speed issue...
Post by: D. Wilson on October 21, 2011, 01:48:00 AM
Just finished downloading. Thanks for the fast reply.