Re: [sqlite] SQLite issues - iPad development

2011-09-21 Thread BareFeetWare
On 22/09/2011, at 4:30 AM, ecky wrote: > I have a SQLITE database I created using the firefox plugin (SQLITE manager). > I'm using that database in my IPAD app and I can read and write to it. What error are you getting? > However... I'm trying to debug some issue with my app so I copy the

Re: [sqlite] Could someone explain why this query is so slow

2011-09-21 Thread Paul Sanderson
Ahh I was sure that this was being created :( ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] c-api document suggestion

2011-09-21 Thread Sean Pieper
a. This is what confused me-- the documentation for the prepare statement mentions this perf boost being quite explicit about including the null, then also makes the ambiguous statement that "the zSQL string ends at either the first '\000' or '\u' character or the nbyteth byte,

[sqlite] MC/DC coverage explained wrong in the home page?

2011-09-21 Thread Sami Liedes
Hi! Looking at http://www.sqlite.org/testing.html it seems to me that MC/DC coverage is explained wrong there. This in turn makes me wonder if SQLite tests really have 100% MC/DC coverage or if this claim is just based on mistaken understanding of MC/DC. The page explains:

Re: [sqlite] sqlite3_analyzer

2011-09-21 Thread Keith Christian
Richard, thank you for the details of the compilation instructions. I'll give that a try. Keith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] c-api document suggestion

2011-09-21 Thread Richard Hipp
On Wed, Sep 21, 2011 at 3:05 PM, Sean Pieper wrote: > There's an apparent inconsistency in the behavior of sqlite3_bind_text and > sqlite3_prepare_v2. > If the user supplies the length of the argument rather than using -1, > bind_text expects that this length exclude the

Re: [sqlite] c-api document suggestion

2011-09-21 Thread Pavel Ivanov
> If the user supplies the length of the argument rather than using -1, > bind_text expects that this length exclude the null termination, whereas > prepare apparently expects it to include the null termination. Can I challenge you in that this conclusion is wrong? Everywhere in the development

Re: [sqlite] c-api document suggestion

2011-09-21 Thread Igor Tandetnik
On 9/21/2011 3:05 PM, Sean Pieper wrote: There's an apparent inconsistency in the behavior of sqlite3_bind_text and sqlite3_prepare_v2. If the user supplies the length of the argument rather than using -1, bind_text expects that this length exclude the null termination, You can include the

Re: [sqlite] SQLITE issues - IPAD development

2011-09-21 Thread Dan Kennedy
On 09/22/2011 01:30 AM, ecky wrote: Howdy I have a SQLITE database I created using the firefox plugin (SQLITE manager). I'm using that database in my IPAD app and I can read and write to it. However... I'm trying to debug some issue with my app so I copy the database file off my IPAD back

[sqlite] c-api document suggestion

2011-09-21 Thread Sean Pieper
There's an apparent inconsistency in the behavior of sqlite3_bind_text and sqlite3_prepare_v2. If the user supplies the length of the argument rather than using -1, bind_text expects that this length exclude the null termination, whereas prepare apparently expects it to include the null

Re: [sqlite] SQLITE issues - IPAD development

2011-09-21 Thread Simon Slavin
On 21 Sep 2011, at 7:30pm, ecky wrote: > I have a SQLITE database I created using the firefox plugin (SQLITE > manager). I'm using that database in my IPAD app and I can read and write > to it. > > However... I'm trying to debug some issue with my app so I copy the database > file off my IPAD

Re: [sqlite] Question about FTS

2011-09-21 Thread Simon Slavin
On 21 Sep 2011, at 6:32pm, Sebastian Bermudez wrote: > How can i know if my shared hosting PHP (sqlite 2 v2.8.17 "2.0-dev $Id: > sqlite.c 298697 2010-04-28 12:10:10Z iliaa $" ) or my PDO (sqlite3 library > v.3.3.7 "(bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z") > support FTS

[sqlite] SQLITE issues - IPAD development

2011-09-21 Thread ecky
Howdy I have a SQLITE database I created using the firefox plugin (SQLITE manager). I'm using that database in my IPAD app and I can read and write to it. However... I'm trying to debug some issue with my app so I copy the database file off my IPAD back to my MAC and try to read the database

Re: [sqlite] sqlite3_analyzer

2011-09-21 Thread Richard Hipp
The way you build sqlite3_analyzer is to download the source tarball and do ./configure make sqlite3_analyzer We are in the middle of changing how sqlite3_analyzer gets built. You are welcomed to try to use the new procedures if you want. But it is currently experimental and subject

Re: [sqlite] sqlite3_analyzer

2011-09-21 Thread Keith Christian
I found the links mentioned above at the bottom of the Downloads page, and went to this site: http://www2.sqlite.org/cgi/src I logged in to the SQLite timeline using anonymous and a random password as instructed. Once there, I downloaded SQLite-256cdbdc810cae23.tar.gz, 3.8 mb in size. After

[sqlite] Question about FTS

2011-09-21 Thread Sebastian Bermudez
How can i know if my shared hosting PHP (sqlite 2 v2.8.17 "2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $" ) or my PDO (sqlite3 library v.3.3.7 "(bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z") support FTS ??? There are some chance to get FTS running without recompile

Re: [sqlite] Could someone explain why this query is so slow

2011-09-21 Thread Igor Tandetnik
On 9/21/2011 12:19 PM, Paul Sanderson wrote: Thanks Igor That makes sense but if I drop MD5 from the query (the vast majority of MD5 values would be null anyway) and use select ID FROM rtable WHERE search> 0 and isf = 0 ORDER BY afo The result from explain query plan is 0|0|0 SCAN TABLE rtable

Re: [sqlite] Could someone explain why this query is so slow

2011-09-21 Thread Paul Sanderson
Thanks Igor That makes sense but if I drop MD5 from the query (the vast majority of MD5 values would be null anyway) and use select ID FROM rtable WHERE search > 0 and isf = 0 ORDER BY afo The result from explain query plan is 0|0|0 SCAN TABLE rtable (~3 rows) >> 0|0|0 USE TEMP B-TREE FOR

Re: [sqlite] Could someone explain why this query is so slow

2011-09-21 Thread Igor Tandetnik
Paul Sanderson wrote: > select ID FROM rtable WHERE search > 0 and MD5 is NULL and isf = 0 ORDER BY > afo > > explain query plan gives the following for the initial query > 0|0|0 SEARCH TABLE rtable USING INDEX md5_a (md5=?) (~2 rows) > 0|0|0 USE TEMP B-TREE FOR

[sqlite] Could someone explain why this query is so slow

2011-09-21 Thread Paul Sanderson
The query below takes about 10 mins to run, any idea why this would be? select ID FROM rtable WHERE search > 0 and MD5 is NULL and isf = 0 ORDER BY afo The same query without the ORDER BY takes a few seconds. select ID FROM rtable WHERE search > 0 and MD5 is NULL and isf = 0 There are

Re: [sqlite] Internal v. External BLOBs

2011-09-21 Thread Teg
My experience is that having larger blobs impacts performance too. It seems like SQlite struggles to seek over the blobs when traversing non-blob containing tables. I haven't characterized it beyond that. It might even be disk caching. I tend to keep my blobs in a different DB file than the

Re: [sqlite] Internal v. External BLOBs

2011-09-21 Thread Alexey Pechnikov
There is a problem with access to file in directory with big amount of files. FS directory indicies are not really good. I did test 100 millions of 1k files in SQLite and results were better than reading from set of directories in FS. But for files about 1 Mb and more the SQLIte performance is not

Re: [sqlite] Internal v. External BLOBs

2011-09-21 Thread Filip Navara
> We did some experiments to try to answer this question, and the results > seemed interesting enough to share with the community at large. Are the test cases available somewhere? I'd be interested in running them on Windows setup with/out SSD. Thanks, Filip Navara