* Pavel Ivanov:
> To answer your original question: if you disable shared cache, start
> reading transaction on one connection and start writing transaction on
> the other connection then you'll be able to read on the first
> connection database in the state it was before writing transaction.
> Bu
Jean-Christophe,
Thanks for your response.
The backup feature looks promising. If we can figure out how to access it
within Django then it looks like it is what we need.
Kevin Yoo
Certification Lead
Wurldtech Security Technologies
1680-401 West Georgia St.
Vancouver, BC, V6B 5A1
Phone: (604
I am out of the office until 06/17/2011.
I'm out of the office but checking email once or twice a day and will
respond to any high importance issues as quickly as possible.
Note: This is an automated response to your message "sqlite-users Digest,
Vol 42, Issue 16" sent on 06/16/2011 6:00:01.
Thank you for everyones help, it was most useful
much appreciated
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
BareFeetWare wrote:
> I have some source data that includes a "Silo And Region" column of two words
> appended together, such as 'NorthPlains',
> 'SouthPlains', 'NorthSlopes', 'SouthSlopes' etc. I want to split them into
> two columns.
>
> How can I do this in SQLite? A regex or offset/positio
On 16 Jun 2011, at 5:27am, BareFeetWare wrote:
> There could be dozens of each but the main issue is that I don't know what
> they are until I get the data. That's what I meant by:
>
>>> I don't know all of the parts (ie "Silo Group" and "Region") until I bring
>>> in the Import.
>
> So I can
> I was trying to create an index on an integer column in a very large
> table with over 400,000,000 rows on an Ubuntu ... I
> increased the cache size to 2 but to no avail.
That's only 200M of cache and your table is much larger. Sqlite can't
index/sort efficiently lare data on disc - you
7 matches
Mail list logo