[sqlite] whish list for 2016

PRAGMA strict_mode = 1; :)

[sqlite] about compile configure

hi,all When we compile the sqlite source code, there are so many configuration, such as SQLITE_DEFAULT_FILE_FORMAT=4; SQLITE_MAX_ATTACHED=30; SQLITE_ENABLE_COLUMN_METADATA; SQLITE_ENABLE_FTS4; My question is that could different configuration influence

[sqlite] about compile configure

On 21 Dec 2015, at 3:17am, ??? <2004wqg2008 at 163.com> wrote: > When we compile the sqlite source code, there are so many > configuration, such as > SQLITE_DEFAULT_FILE_FORMAT=4; > SQLITE_MAX_ATTACHED=30; > SQLITE_ENABLE_COLUMN_METADATA; > SQLITE_ENABLE_FTS4; >

[sqlite] about compile configure

How about the following settings: SQLITE_DEFAULT_FILE_FORMAT=4; SQLITE_MAX_ATTACHED=30; SQLITE_ENABLE_COLUMN_METADATA; SQLITE_ENABLE_FTS4; SQLITE_ENABLE_FTS4_PARENTHESIS; SQLITE_ENABLE_RTREE; SQLITE_THREADSAFE=2; NDS_ENABLE_ZLIB; NDS_ENABLE_AES; NDS_ENABLE_COLLATIONS At 2015-12-21 11:42:14,

[sqlite] about compile configure

On 21 Dec 2015, at 3:50am, ??? <2004wqg2008 at 163.com> wrote: > How about the following settings: Read the documentation for those settings. Given what they do which ones, if any, do you think will influence performance ? Simon.

[sqlite] about compile configure

Thank you very much. At 2015-12-21 11:54:13, "Simon Slavin" wrote: > >On 21 Dec 2015, at 3:50am, ??? <2004wqg2008 at 163.com> wrote: > >> How about the following settings: > >Read the documentation for those settings. Given what they do which ones, if >any, do you think will influence

[sqlite] about compile configure

On 21 Dec 2015, at 3:56am, ??? <2004wqg2008 at 163.com> wrote: > Thank you very much. Why are you asking your question ? Is your program which uses SQLite too slow ? If so, how much too slow is it ? Just a little bit or a lot too slow ? Simon.

[sqlite] about compile configure

hi,Simon. The reason why I asked the question is that I want to improve the spped, although the current SQLite is not too slow. But the speed is not very ideal. So I still try any methods to improve the performance of SQLite. I will try the following aspects: first method ,

[sqlite] about compile configure

On 21 Dec 2015, at 4:23am, ??? <2004wqg2008 at 163.com> wrote: >first method , configure settings; >second method , the other is how to use sqlite_table, could the > sqlite_master table help us improve performance ? Okay, now I can help you. Neither of those things will help with

[sqlite] What does output from integrity check mean and how can I prevent this?

Hi, Using sqlite dbs for my program (official .NET sqlite.interop.dll, v. 1.0.92.0). Have not had any db integrity issues until today. One user send me a db, I ran Sqlite Expert professionals's integrity checker and got this: *** in database main *** On tree page 2 cell 14: 2nd reference to

[sqlite] What does output from integrity check mean and how can I prevent this?

On 21 Dec 2015, at 5:04am, Andy KU7T wrote: > How could this be happening? Disk failure, power failure, etc? Those things seem the most likely in the circumstances but there are some other possibilities: > How can this be detected at run time (can

[sqlite] about compile configure

>Is your speed problem with a SELECT ? If so, can you past your SELECT into a >message for us ? The speed problem has nothing to do with a SELECT >Are you using multiple threads or multiple processes ? NO At 2015-12-21 12:53:09, "Simon Slavin" wrote: > >On 21 Dec 2015, at

[sqlite] about compile configure

>What do you mean "how to use sqlite_table"? Do you mean how to design >effective database tables and query them efficiently using SQL? The meaning of "how to use sqlite_table" is that I guess the sqlite_table may have contained some information which could help to improve speed. I am not

[sqlite] Use of DELETE LIMIT OFFSET with ENABLE_UPDATE_DELETE_LIMIT

2015-12-19 21:57 GMT+01:00 Jeremy Boy : > I would like to use the optional LIMIT and ORDER BY clause for DELETE > statements in SQLite. I can verify that SQLite was built with > SQLITE_ENABLE_UPDATE_DELETE_LIMIT: This doesn't work when sqlite is buillt from the amalamation, which is clearly

[sqlite] about compile configure

On 21 Dec 2015, at 6:19am, ??? <2004wqg2008 at 163.com> wrote: > The meaning of "how to use sqlite_table" is that I guess the sqlite_table > may have contained some information which could help to improve speed. > I am not meaning to modify the data structure of sqlite_master. There is

[sqlite] about compile configure

What Simon said is very helpful for me. Thank you very much. I only want to improve the speed of reading data from data base. Do not do insert?update and so on. I will try the following suggustion. PRAGMA synchronous = OFF Best regards At 2015-12-21 17:03:13, "Simon Slavin" wrote: >

[sqlite] about compile configure

The SQL statement is so easy. the table create statement as following: CREATE TABLE poiTable (poiId INTEGER NOT NULL, versionId INTEGER NOT NULL, regionId INTEGER , postalCode TEXT , phone TEXT , attrBitMask INTEGER , attributeBlob BLOB , primary key (poiId)); So the poiId is

[sqlite] about compile configure

On 21 Dec 2015, at 10:07am, ??? <2004wqg2008 at 163.com> wrote: >CREATE TABLE poiTable (poiId INTEGER NOT NULL, versionId INTEGER NOT NULL, > regionId INTEGER , postalCode TEXT , phone TEXT , attrBitMask INTEGER , > attributeBlob BLOB , primary key (poiId)); >So the poiId is equal to

[sqlite] 答复: about compile configure

pragma mmap_size= 51200; Pragma page_size = 8192; Vacuum; Pragma cache_size = N; ???: ??? : ?2015/?12/?21 18:08 ???: SQLite mailing list ??: Re: [sqlite] about compile configure

[sqlite] 答复: about compile configure

>pragma mmap_size = 51200; >Pragma page_size = 8192; The number 51200 and 8192, how do you compute them? >Vacuum; >Pragma cache_size = N; What number is N? At 2015-12-21 18:29:37, "Quan Yong Zhai" wrote: >pragma mmap_size= 51200; >Pragma page_size = 8192; >Vacuum;

[sqlite] sqlite3.c:89394: int sqlite3ExprCompare(Expr *, Expr *, int): Assertion `0' failed.

On 12/20/15, Jonathan Metzman wrote: > When fuzzing with AFL, I found that running the commands below on the > sqlite shell (sqlite-amalgamation-201511301915.zip) results in the > assertion failure: "sqlite3.c:89394: int sqlite3ExprCompare(Expr *, Expr *, > int): Assertion `0' failed." > > The

[sqlite] whish list for 2016

> On Dec 21, 2015, at 4:08 AM, Darren Duncan wrote: > > If you want that feature, instead do it the better way that Postgres 9.5 did, > which is as an extension to the INSERT statement in the form "ON CONFLICT DO > UPDATE/IGNORE?. Please, enough of the comic act :P MERGE it is. Oh, yes,

[sqlite] whish list for 2016

On 2015-12-21 8:25 AM, Petite Abeille wrote: >> On Dec 21, 2015, at 4:08 AM, Darren Duncan >> wrote: >> >> If you want that feature, instead do it the better way that Postgres 9.5 >> did, which is as an extension to the INSERT statement in the form "ON >> CONFLICT DO UPDATE/IGNORE?. > >

[sqlite] whish list for 2016

> On Dec 21, 2015, at 5:43 PM, Darren Duncan wrote: > > Comic act? Do you consider the MERGE defined in the SQL standard to be a > better designed feature than Postgres' alternative, Yes. > or do you prefer the former soley because it is in the SQL standard? Yes. > I recall that Postgres

[sqlite] whish list for 2016

On 2015-12-21 3:46 PM, lchishol at paradise.net.nz wrote: > Joining the throng, here are my requests: > a) Either an ORDER BY clause/equivalent for GROUP BY, or an assurance that the > kludge of sorting a sub-query first and then grouping the result does and will > continue to work - I need this