On 04/22/2016 02:59 PM, Dominique Devienne wrote:
>> But, if your process has two separate database handles and they both
>> attach "file:data.db?mode=memory=shared" then both handles will be
>> connected to the same in-memory database.
>
> This is exactly what we are doing. Now I keep on reading
On Thu, Apr 21, 2016 at 8:20 PM, Dan Kennedy wrote:
> Generally speaking, no matter how they are created, a given in-memory
>> database has one and only one connection. You cannot, for example, use a
>> URI ?filename? with mode=memory to open the same in-memory database more
>> than once (I
> Generally speaking, no matter how they are created, a given in-memory
> database has one and only one connection. You cannot, for example, use a URI
> ?filename? with mode=memory to open the same in-memory database more than
> once (I assume that?s what you mean by ?by name??). For
On Apr 20, 2016, at 8:10 AM, Dominique Devienne wrote:
> Thanks. I mistakenly assumes ":memory:" was a "singleton" memory DB
> for that particular connection. Thanks to your example, and a little testing
> on my own, I now realize
> each one is an independent memory DB, and not just different
On Wed, Apr 20, 2016 at 2:49 PM, Jay Kreibich wrote:
> > To attach several memory DBs, it's more like
> >
> > ATTACH DATABASE "file:mem1?mode=memory" as db1;
> > ATTACH DATABASE "file:mem2?mode=memory" as db2;
> > etc... ?DD
>
> There is no requirement to use the URI style file type, you can
On 2016/04/19 10:48 PM, R Smith wrote:
>
>
> On 2016/04/19 8:34 PM, Jarred Ford wrote:
>> Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between them? For example, select
>> * from db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x =
On Wed, Apr 20, 2016 at 10:22 AM, Dominique Devienne
wrote:
> On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>>
>> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>>
>> > Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between
On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>
> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>
> > Is it possible to create multiple in-memory databases and be able to
> access tables with a single query between them?
> > For example, select * from db1.dbo.table1 db1 join
On Apr 20, 2016, at 3:22 AM, Dominique Devienne wrote:
> On Wed, Apr 20, 2016 at 4:40 AM, Jay Kreibich wrote:
>>
>> On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
>>
>>> Is it possible to create multiple in-memory databases and be able to
>> access tables with a single query between them?
Am 19.04.2016 um 20:34 schrieb Jarred Ford:
> Is it possible to create multiple in-memory databases and be able to access
> tables with a single query between them? For example, select * from
> db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
Yes, that's possible over appropriate
On 2016/04/19 8:34 PM, Jarred Ford wrote:
> Is it possible to create multiple in-memory databases and be able to access
> tables with a single query between them? For example, select * from
> db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
No. An in-memory database has no
On Apr 19, 2016, at 1:34 PM, Jarred Ford wrote:
> Is it possible to create multiple in-memory databases and be able to access
> tables with a single query between them?
> For example, select * from db1.dbo.table1 db1 join db2.dbo.table1 db2 on
> db1.x = db2.x.
>
Sure. Like any other
Is it possible to create multiple in-memory databases and be able to access
tables with a single query between them? For example, select * from
db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
Thanks.
13 matches
Mail list logo