Re: [sqlite] Slowness with FTS Queries and non-FTS tables

2013-05-08 Thread Scott Robison
On Tue, May 7, 2013 at 1:53 PM, Dan Kennedy wrote: > > Another way to go is to use the 'merge=X,Y' and 'automerge=0' commands: > > > http://www.sqlite.org/fts3.**html#mergecmd > > I tried a few variations on merging and

Re: [sqlite] Store sqlite database problem

2013-05-08 Thread Fehmi Noyan ISI
This question is more C related than SQlite... You were advised to use www.programming.com in your previous posts, portal has a good programming forum. From: Newbie89 To: sqlite-users@sqlite.org Sent: Thursday, May 9, 2013 1:40 AM

[sqlite] New preview snapshots for 3.7.17

2013-05-08 Thread Richard Hipp
New amalgamation snapshots for the upcoming 3.7.17 release can be found at http://www.sqlite.org/draft/download.html Please try this snapshot in your applications and report success or failure, either to this mailing list or directly to me. Thanks. -- D. Richard Hipp d...@sqlite.org

[sqlite] Store sqlite database problem

2013-05-08 Thread Newbie89
How to store data for 1 minute then update the database?any idea to do it?using sqlite and c language...is it just use delete and insert query to make it? -- View this message in context: http://sqlite.1065341.n5.nabble.com/Store-sqlite-database-problem-tp68745.html Sent from the SQLite

Re: [sqlite] Very important performance regression due to totally different query plan

2013-05-08 Thread Stephane MANKOWSKI
Hi Richard, Yes, I already considered including source code but this is not so easy because I develop in fact with QT and the sqlite driver. Anyway, the main reason of my initial post is to: 1-inform you about this important performance regression 2-know if this is normal or if I have to open

Re: [sqlite] How to read log file format into sqlite database?

2013-05-08 Thread Newbie89
Jay A. Kreibich wrote > On Sun, May 05, 2013 at 01:50:41AM -0700, Newbie89 scratched on the wall: >> let say is .txt file > > 99+% of log files are text files. This tells us nothing useful. > > > Is it an Apache log file? Or some other well-known format that > someone might have already