Re: [sqlite] update record in contentless FTS4

On Fri, Apr 12, 2013 at 9:28 AM, Lukas Gebauer wrote: > I have contentless FTS4 index for searching some my external data > paired by docid. > > What I can do, when my existing previously indexed document was > changed? I need to update existing FTS4 index too. But documentation

[sqlite] Need Help

Hi, I am new to sqlite and my objective is to run the sqlite tests on build where sqlite got integrated and have to use my own ZFS for my test. I have downloaded the source where tests are available but need help on how to take them and run against sqlite which is integrated in our code. Can

Re: [sqlite] Help speed up query

Simon and everyone who has thrown ideas into the mix, I very much appreciate the effort that you folks have put into this! If nothing else, I am learning from this exorcise. I set the page_size to 4096 and cache_size to 1024. (I picked the next binary size above the 2976 KB size of the DB under

Re: [sqlite] Help speed up query

Have you tried increase sqlite cache size and page size? pragma cache_size; pragma page_size; Try making page_size=4096 Then make cache_size*page_size as big as your database file. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On

Re: [sqlite] Help speed up query

On 16 Apr 2013, at 7:10pm, ven...@intouchmi.com wrote: > I tried transfering the database to an in memory copy and running the > queries. It is actually a little slower but not much. I'm sure there are > tables that are not being accessed and so loading them into memory would add > to the

Re: [sqlite] Help speed up query

I tried transfering the database to an in memory copy and running the queries. It is actually a little slower but not much. I'm sure there are tables that are not being accessed and so loading them into memory would add to the time. Vance on Apr 16, 2013, ven...@intouchmi.com wrote: > >Yes,

[sqlite] RTree Documentation Error?

Hi, I was looking at the RTree documentation page with one of my colleagues - http://www.sqlite.org/rtree.html We tried the example with the schema in 3.1, populated the data from 3.2 and then queried it using the query of 3.3 - we got no results while the documentation says that "the query

Re: [sqlite] Help speed up query

Yes, the DBs are on my local disk. The quoted times are after the first run so mostly in cache. It takes about twice the time the first run for both SQLite and MS Access. Vance on Apr 16, 2013, Simon Slavin wrote: > > >On 16 Apr 2013, at 2:32pm, ven...@intouchmi.com

Re: [sqlite] Help speed up query

Interesting ... The query is simply descending a tree and I should think it would be fast. Object_Types Objects DTC_Statuses Object_TextTables DisplayFormats Object_Transactions Equations Equation_Types Which would need the following indexes for traversal. For column retrieval,

Re: [sqlite] Help speed up query

On 16 Apr 2013, at 2:32pm, ven...@intouchmi.com wrote: > It was about 380 ms. Now it is taking about 610 ms. Can I check with you that the database file is stored on a disk of the computer which is executing the SQLite commands ? In other words, that this is a local hard disk and not one

Re: [sqlite] Help speed up query

removing the parenthesises (what is the plural?) made no difference to the query plan which is: 0|0|6|SEARCH TABLE Object_Types USING COVERING INDEX sqlite_autoindex_Object_Types_1 (Object_Type=?) (~1 rows) 0|1|1|SCAN TABLE DTC_Statuses (~100 rows) 0|2|0|SEARCH TABLE Objects USING INTEGER

Re: [sqlite] Beginning database question

I assume when you say "discrete" you actually mean "bracketed" as there are lots more than 10 heights and weights. I don't know what Excel has to do with this unless you programmed the whole thing in Excel already? Is speed really a concern? This does sound like a fairly trivial programming

[sqlite] Minor typo in release notes

Hi, In http://www.sqlite.org/changes.html , the last change is noted as 2012-04-12 (3.7.16.2). It should probably be 2013 :) Regards, Cédric Cédric VENET Software Engineer - Schlumberger, MpTC Email: cve...@slb.com Tel: +33 4 30 63 85 18

[sqlite] Beginning database question

Hi All, I'm an amateur programmer who has never worked with databases before. I *think* that getting started with SQLite may help with some of my projects, but I'm having trouble determining exactly how. I'm hoping someone in this list may be able to point me in the right direction. My

[sqlite] Using from Windows8 background task

It seems when I call sqlite3_step from within a background task context it does not execute the statement at all. Trying to step into the code it terminates the background process host exe when setting the mutex. This seems rather strange, since the same code works for normal Win8 apps.

Re: [sqlite] Help speed up query

On Mon, Apr 15, 2013 at 11:02 PM, Simon Slavin wrote: > On 15 Apr 2013, at 9:47pm, ven...@intouchmi.com wrote: > > My software was not locked up totally. It did finally come back. For > some reason executing analyze slow other queries way down. > > I am surprised by

Re: [sqlite] Help speed up query

Have you tried removing all the useless brackets that Micro$oft adds to the query? I don't know if the parser strips them out automagically or if they are used as join order hints. You are better off letting the optimizer optimize unless you really really want to force a specific order.