On Feb 21, 2009, at 5:57 AM, Clark Christensen wrote:
>
> Hello,
>
> In the docs for ATTACH, I see this information:
>
> Transactions involving multiple attached databases are atomic,
> assuming that the main database is not ":memory:". If the main
> database is ":memory:" then
> transactions co
On Feb 21, 2009, at 2:59 AM, Jay A. Kreibich wrote:
> On Fri, Feb 20, 2009 at 11:56:52AM -0500, Boucher, Michael scratched
> on the wall:
>> Hi there,
>>
>> I need to migrate data from a different database into a SQLite
>> database.
>> What I've done is written a simple C++ app which opens bo
Hello,
I am using sqlite in an embedded environment with very limited memory.
In an attempt to reduce memory consumed by sqlite, I am executing
PRAGMA cache_size=new_size and PRAGMA default_cache_size=new_size upon
opening all of my db's, which are both file based and in-memory. I
have varied the v
Hello,
In the docs for ATTACH, I see this information:
Transactions involving multiple attached databases are atomic,
assuming that the main database is not ":memory:". If the main
database is ":memory:" then
transactions continue to be atomic within each individual
database file. But if the h
Interesting point about indexes not being updated until the
transaction commits. I'm still curious why dropping and recreating
the indexes is seen as a bad thing though...
On Fri, Feb 20, 2009 at 2:59 PM, Jay A. Kreibich wrote:
> On Fri, Feb 20, 2009 at 11:56:52AM -0500, Boucher, Michael scra
On Fri, Feb 20, 2009 at 11:56:52AM -0500, Boucher, Michael scratched on the
wall:
> Hi there,
>
> I need to migrate data from a different database into a SQLite database.
> What I've done is written a simple C++ app which opens both databases,
> does a select from one and an insert into the other
BareFeet wrote:
> Hi John,
>
>> You still miss the point of the cross reference ID. It is NOT the
>> reference ID od the document, such as an invoice or check number,
>> but it
>> more like the row ID used by Sqlire as a unique key for a DB row.
>
> I thought, from your explanation, that was w
Ionut Subasu writes:
>
> Hi everybody,
>
> I am trying to do some changes to sqlite and I use as IDE Eclipse and as OS
> Linux.
> Due to the large size of the file, the environment is verry slow on editing.
>
> I have checked out the indication on the SQLite web site (
> http://www.sqlite.org/
Nope, that's the solution. :)
On Fri, Feb 20, 2009 at 11:56 AM, Boucher, Michael
wrote:
> Hi there,
>
>
>
> I need to migrate data from a different database into a SQLite database.
> What I've done is written a simple C++ app which opens both databases,
> does a select from one and an insert i
Hi there,
I need to migrate data from a different database into a SQLite database.
What I've done is written a simple C++ app which opens both databases,
does a select from one and an insert into the other.
I'm wondering if there is a way to delay indexing on the insert. I'm
going to be in
Yes, that does help me. Thank you for sharing!
-Dan
Rajesh Nair-5 wrote:
>
> I have a real time program which logs more than 30,000 records, each
> record of about 200 bytes, per day and the company in which it has
> been installed is working 24/365. I installed the project on 2005
> August and
On 20/02/2009 12:35 PM, BareFeet wrote:
> Hi John (Machin),
>
> Thanks for the discussion.
>
>>> I understand that double entry bookkeeping traditionally uses the
>>> redundancy as an error check, but that seems more appropriate for
>>> manual paper systems, since computer systems can validat
12 matches
Mail list logo
