PRAGMA cache_size and ATTACHED DBs

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

PRAGMA cache_size and ATTACHED DBs

jose isaias cabrera

Greetings!

When connecting to a DB, and setting a PRAGMA cache_size, will the
attached DB also respond/behave the same way/size set by the original
connection?

Thanks.

josé
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: PRAGMA cache_size and ATTACHED DBs

R Smith
The cache size pragma dictates to (and affects) the connection, not the DB.

So yes.


On 2015-08-24 07:30 PM, jose i cabrera wrote:

>
> Greetings!
>
> When connecting to a DB, and setting a PRAGMA cache_size, will the
> attached DB also respond/behave the same way/size set by the original
> connection?
>
> Thanks.
>
> josé
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: PRAGMA cache_size and ATTACHED DBs

jose isaias cabrera

thanks.


On 8/24/2015 1:34 PM, R.Smith wrote:

> The cache size pragma dictates to (and affects) the connection, not
> the DB.
>
> So yes.
>
>
> On 2015-08-24 07:30 PM, jose i cabrera wrote:
>>
>> Greetings!
>>
>> When connecting to a DB, and setting a PRAGMA cache_size, will the
>> attached DB also respond/behave the same way/size set by the original
>> connection?
>>
>> Thanks.
>>
>> josé
>> _______________________________________________
>> sqlite-users mailing list
>> [hidden email]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users