Re: [sqlite] [PATCH] cache preloading

2010-08-11 Thread Damian Pietras
On Tue, Aug 10, 2010 at 05:46:26PM -0700, Paweł Hajdan, Jr. wrote: > So this is another chromium patch I'd like to submit: > http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/preload-cache.patch?revision=26596&view=markup > > I'm not the author of that one, but the main idea seems

Re: [sqlite] Mozilla History Autodelete

2010-08-11 Thread Artur Reilin
Do you have the option activated, that your history will be cleaned all ## days? Also, do you use something like places cleaner or so? (Btw. I think it's funny to store icons in an sqlite database ...) Artur > > Hi there , I have a problem . My FF history autodelete itself sometime and > i do no

[sqlite] Mozilla History Autodelete

2010-08-11 Thread All Marri
Hi there , I have a problem . My FF history autodelete itself sometime and i do not know why also i would ask to you how to find the deleted history / bookmarks . Tnx for help and patience and sorry for my bad english .

Re: [sqlite] Write-ahead logging and database locking

2010-08-11 Thread Pavel Ivanov
> Also, I see in the documentation that when shared-cache mode is enabled, > SQLite uses table-level locking (instead of the default file-locking). > Taken all together, it suggests that you can get table-level locking > *and* write-ahead logging *and* atomic multi-table commits -- all within > a s

Re: [sqlite] severe slowdown for sub-queries, solved in 3.7?

2010-08-11 Thread Black, Michael (IS)
The patch that fixed your problem was on 2010-04-07 I've attached a patch from 3.6.23 to that version. It's 1849 lines of so that's not too bad for QA. I've also attached a context diff too. A bit easier to read if you need QA to look at it. The sqlite3 source is too big for an attachment

Re: [sqlite] severe slowdown for sub-queries, solved in 3.7?

2010-08-11 Thread Black, Michael (IS)
My patches are awating moderator approval so I figured I'd just send out the info in case they get killed. See below to fix your problem with a minimal patch. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems ___

Re: [sqlite] .import FILE TABLE

2010-08-11 Thread Oliver Peters
Larry Siden writes: > > What is the format of the file? I cannot find it documented anywhere. It is a csv file with the same fields in the same order as your table has. You can set the separator of the csv this way .separator \t (\t == tab, default is |) Oliver _