On 7 Aug 2014, at 3:24pm, Giuseppe Costanzi <giuseppecosta...@gmail.com> wrote:
> I have finished running ANALYZE and SQLite commands are taking longer > only when I use python db api > such as > [...] > > however I have done what you have pointed out me and in effects the > speed of execution > from the shell is best after having performed ANALYZE > as I would be me expected [snip] > I have also noticed that, using python db api2 if I perform a query > recalling a view on the database > this it is slower if I directly write the query in the script of python > For example if I perform [...] > and this independently from ANALTYZE but after run ANALYZER the > situation worsens Very good. If you had a situation where the Shell Tool got slower on ANALYZE then it would definitely be an error in SQLite and we could investigate. But you are reporting a situation where the Shell Tool gets faster but Python gets slower. This makes me think that the fault is with your Python library. I don't know enough about Python to help. I am going to hope that someone familiar with Python sees this and can help you. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
