Dennis Cote wrote:
> That looks right to me.
>
Thanks for the quick check, Dennis.
> There is no need to create an index on the temporary id_list, since you
> are going to be doing a full table scan of that table anyway.
>
>select *
>from id_list
>join mt.table on mt.table.id = id
Mohit Sindhwani wrote:
>
> Since the database is to be created and deleted in a thread itself, I
> think I may need to do something like:
> * Create in-memory database (":memory:")
> * Attach the main database (from file) as 'mt'
> * Create the temporary table for id_list
> * Insert the user ente
Ken wrote:
> I'll take a stab at this.
>
> Each connection would have its own private memory database.
>
> Create an additional temp table id_list , Insert the user id set values into
> this table.
>
> Then
> INSERT INTO temptab tt SELECT mt.* FROM maintab mt, id_list
>
Ken wrote:
> I'll take a stab at this.
>
> Each connection would have its own private memory database.
>
> Create an additional temp table id_list , Insert the user id set values into
> this table.
>
> Then
> INSERT INTO temptab tt SELECT mt.* FROM maintab mt, id_list
>
mt.id = idl.id ;
Then delete the id_list table or drop it.
HTH,
Ken
--- On Wed, 9/10/08, Mohit Sindhwani <[EMAIL PROTECTED]> wrote:
From: Mohit Sindhwani <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Considerations with in-memory SQLite3
To: "General Discussion of SQLite Database"
Da
Hi Richard
Thanks for the quick response!
D. Richard Hipp wrote:
> On Sep 10, 2008, at 2:09 PM, Mohit Sindhwani wrote:
>
>>
>> I've been using SQLite3 for a while though to be honest, it's been
>> more
>> of a data store rather than a dynamic database in my applications this
>> far. I'm now
On Sep 10, 2008, at 2:09 PM, Mohit Sindhwani wrote:
> Hi Everyone,
>
> I'm new to the list and would like to start by saying hello! So,
> hello!
>
> I've been using SQLite3 for a while though to be honest, it's been
> more
> of a data store rather than a dynamic database in my applications t
Hi Everyone,
I'm new to the list and would like to start by saying hello! So, hello!
I've been using SQLite3 for a while though to be honest, it's been more
of a data store rather than a dynamic database in my applications this
far. I'm now starting on something where my needs are as such:
*
8 matches
Mail list logo
