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
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
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,
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:
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
> 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
23 matches
Mail list logo