Hello Pavel,
I now upgraded to 3.7.6.2 and it is much better now!
Thank you very much for your help!
Regards,
Mathias
On Mon 18/04/11 17:06 , "Pavel Ivanov" paiva...@gmail.com sent:
OK, sorry I didn't tell you all possible word combinations to look
for. It looks like release notes use "query
OK, sorry I didn't tell you all possible word combinations to look
for. It looks like release notes use "query planner" instead of
"optimizer".
Pavel
On Mon, Apr 18, 2011 at 10:09 AM, Spoerr Mathias wrote:
> the last Optimizer enhancement was with 3.6.22
> http://www.sqlite.org/changes.html
>
the
last Optimizer enhancement was with 3.6.22
http://www.sqlite.org/changes.html
Thanks,
Mathias
On Mon 18/04/11 16:05 , "Pavel Ivanov" paiva...@gmail.com sent:
> I checked
> the SQLite release notes and I could not find changes for
sqlite3_step.
> Should I upgrade anyway?
Did you notice i
> I checked
> the SQLite release notes and I could not find changes for sqlite3_step.
> Should I upgrade anyway?
Did you notice in release notes something like "optimizer
improvements"? That's what impacts the sqlite3_step performance.
Pavel
On Mon, Apr 18, 2011 at 9:54 AM, Spoerr Mathias wro
users-boun...@sqlite.org] Im Auftrag von Igor Tandetnik
Gesendet: Montag, 18. April 2011 15:55
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Performance issues with sqlite3 sqlite3_step function
Mathias Spoerr wrote:
> I have problems with a specific query when using the "sqlite
Mathias Spoerr wrote:
> I have problems with a specific query when using the "sqlite3_step"
> function:
>
>SELECT DISTINCT interfaces_int_id,device_dev_id FROM devInterface
>
>INNER JOIN interfaces ON
> devInterface.interfaces_int_id=interfaces.intf_id
>
>INNER JOIN nlink ON nlink.i
Hello Pavel,
thank you for your answer. SQLite Manager uses version 3.7.4, but I
checked the SQLite release notes and I could not find changes for
sqlite3_step. Should I upgrade anyway?
Thanks,
Mathias
On Mon 18/04/11 15:49 , "Pavel Ivanov" paiva...@gmail.com sent:
> Depending on the database
> Depending on the database size, it sometimes takes minutes to get a result.
> But when using the Firefox plugin "SQLite Manager", it "only" takes 1-2
> seconds.
>
> I use SQLITE Version 3.6.22.
Maybe SQLite Manager uses newer version of SQLite? Try to execute in
it "SELECT sqlite_version()"
Hello,
I have problems with a specific query when using the "sqlite3_step"
function:
SELECT DISTINCT interfaces_int_id,device_dev_id FROM devInterface
INNER JOIN interfaces ON
devInterface.interfaces_int_id=interfaces.intf_id
INNER JOIN nlink ON nlink.interfaces_intf_id=inte
9 matches
Mail list logo
