sqlite3_limit equivalent in System.Data.SQLite.dll

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

sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
The default limit for the number of attached databases appears to be 10 with the 1.0.106 version of System.Data.SQLite.dll and I would like to increase this value to 25. I've used the sqlite3_limit function in the past to increase this value but I don't see a matching way to do this within System.Data.SQLite.dll.

Thanks in advance for your assistance.

Keith
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Joe Mistachkin-3

Keith Bertram wrote:
>
> The default limit for the number of attached databases appears to be 10
with the
> 1.0.106 version of System.Data.SQLite.dll and I would like to increase
this value
> to 25. I've used the sqlite3_limit function in the past to increase this
value
> but I don't see a matching way to do this within System.Data.SQLite.dll.
>

Thanks for pointing this out.  I'll make sure that some way to accomplish
this ends
up in the 1.0.112.0 release, which is due out shortly.

--
Joe Mistachkin

_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
Ok. Thanks. Do you have an estimated release date?

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
Sent: Wednesday, October 23, 2019 9:08 PM
To: 'SQLite mailing list' <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


Keith Bertram wrote:
>
> The default limit for the number of attached databases appears to be
> 10
with the
> 1.0.106 version of System.Data.SQLite.dll and I would like to increase
this value
> to 25. I've used the sqlite3_limit function in the past to increase
> this
value
> but I don't see a matching way to do this within System.Data.SQLite.dll.
>

Thanks for pointing this out.  I'll make sure that some way to accomplish this ends up in the 1.0.112.0 release, which is due out shortly.

--
Joe Mistachkin

_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk&s=sCLCkHRvR-ztdvVVSGxqaiz1a_tcrqNlHTio4zORCuE&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Joe Mistachkin-3

Within the next week or so.

Sent from my iPhone

> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[hidden email]> wrote:
>
> Ok. Thanks. Do you have an estimated release date?
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
> Sent: Wednesday, October 23, 2019 9:08 PM
> To: 'SQLite mailing list' <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
>
>
> Keith Bertram wrote:
>>
>> The default limit for the number of attached databases appears to be
>> 10
> with the
>> 1.0.106 version of System.Data.SQLite.dll and I would like to increase
> this value
>> to 25. I've used the sqlite3_limit function in the past to increase
>> this
> value
>> but I don't see a matching way to do this within System.Data.SQLite.dll.
>>
>
> Thanks for pointing this out.  I'll make sure that some way to accomplish this ends up in the 1.0.112.0 release, which is due out shortly.
>
> --
> Joe Mistachkin
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk&s=sCLCkHRvR-ztdvVVSGxqaiz1a_tcrqNlHTio4zORCuE&e= 
> _______________________________________________
> 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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
Ok. Thanks. Does it get immediately placed under nuget?

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
Sent: Thursday, October 24, 2019 8:12 AM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


Within the next week or so.

Sent from my iPhone

> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[hidden email]> wrote:
>
> Ok. Thanks. Do you have an estimated release date?
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On
> Behalf Of Joe Mistachkin
> Sent: Wednesday, October 23, 2019 9:08 PM
> To: 'SQLite mailing list' <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in
> System.Data.SQLite.dll
>
>
> Keith Bertram wrote:
>>
>> The default limit for the number of attached databases appears to be
>> 10
> with the
>> 1.0.106 version of System.Data.SQLite.dll and I would like to
>> increase
> this value
>> to 25. I've used the sqlite3_limit function in the past to increase
>> this
> value
>> but I don't see a matching way to do this within System.Data.SQLite.dll.
>>
>
> Thanks for pointing this out.  I'll make sure that some way to accomplish this ends up in the 1.0.112.0 release, which is due out shortly.
>
> --
> Joe Mistachkin
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit
> e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd
> _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T
> sA-hoNTc&m=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk&s=sCLCkHRvR-ztd
> vVVSGxqaiz1a_tcrqNlHTio4zORCuE&e=
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit
> e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd
> _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T
> sA-hoNTc&m=ToaKjNz0BYd7qdR5qRjM5upVh5PLjdoYkQe5hWOHkGQ&s=MRsMclki0g0JT
> pTyrcS2EvjvvP5z5dOAS2yXbUYta8c&e=
>

_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=ToaKjNz0BYd7qdR5qRjM5upVh5PLjdoYkQe5hWOHkGQ&s=MRsMclki0g0JTpTyrcS2EvjvvP5z5dOAS2yXbUYta8c&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Joe Mistachkin-3

Yes, the NuGet packages are included in the release.

Sent from my iPhone

> On Oct 24, 2019, at 9:13 AM, Keith Bertram <[hidden email]> wrote:
>
> Ok. Thanks. Does it get immediately placed under nuget?
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
> Sent: Thursday, October 24, 2019 8:12 AM
> To: SQLite mailing list <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
>
>
> Within the next week or so.
>
> Sent from my iPhone
>
>> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[hidden email]> wrote:
>>
>> Ok. Thanks. Do you have an estimated release date?
>>
>> Keith
>>
>> -----Original Message-----
>> From: sqlite-users <[hidden email]> On
>> Behalf Of Joe Mistachkin
>> Sent: Wednesday, October 23, 2019 9:08 PM
>> To: 'SQLite mailing list' <[hidden email]>
>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>> System.Data.SQLite.dll
>>
>>
>> Keith Bertram wrote:
>>>
>>> The default limit for the number of attached databases appears to be
>>> 10
>> with the
>>> 1.0.106 version of System.Data.SQLite.dll and I would like to
>>> increase
>> this value
>>> to 25. I've used the sqlite3_limit function in the past to increase
>>> this

_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
Hello,

I'm attempting to use the new SetLimitOption added to the 1.0.112 version of System.Data.SQLite.dll. Either I'm not using this function correctly or there is a problem within the dll. Any help you can provide is greatly appreciated.

        private void Button_Click (object sender, RoutedEventArgs e)
            {
            int iRequestValue = 20;
            String fName = @"d:\vancouver\OpenCommsCPV.db";
            String connStr = String.Format("Data Source={0}, Version=3", fName);
            SQLiteConnection conn = new SQLiteConnection(connStr);
            conn.Open();

            int iOldValue = conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, iRequestValue);
            int iNewValue = conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, -1);  // Pass -1 to get the current value.
            if ( iNewValue != iRequestValue )
                {
                MessageBox.Show("Setting Num Attachments limit failed.");
                }
            else
                {
                MessageBox.Show("Setting Num Attachments limit succeeded.");
                }
            }

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
Sent: Thursday, October 24, 2019 8:36 AM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


Yes, the NuGet packages are included in the release.

Sent from my iPhone

> On Oct 24, 2019, at 9:13 AM, Keith Bertram <[hidden email]> wrote:
>
> Ok. Thanks. Does it get immediately placed under nuget?
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On
> Behalf Of Joe Mistachkin
> Sent: Thursday, October 24, 2019 8:12 AM
> To: SQLite mailing list <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in
> System.Data.SQLite.dll
>
>
> Within the next week or so.
>
> Sent from my iPhone
>
>> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[hidden email]> wrote:
>>
>> Ok. Thanks. Do you have an estimated release date?
>>
>> Keith
>>
>> -----Original Message-----
>> From: sqlite-users <[hidden email]> On
>> Behalf Of Joe Mistachkin
>> Sent: Wednesday, October 23, 2019 9:08 PM
>> To: 'SQLite mailing list' <[hidden email]>
>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>> System.Data.SQLite.dll
>>
>>
>> Keith Bertram wrote:
>>>
>>> The default limit for the number of attached databases appears to be
>>> 10
>> with the
>>> 1.0.106 version of System.Data.SQLite.dll and I would like to
>>> increase
>> this value
>>> to 25. I've used the sqlite3_limit function in the past to increase
>>> this

_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=e4b8CwDAzK1-TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI&s=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW0Xea6A&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Medcalf

What did you define SQLITE_MAX_ATTACHED as when you compiled the DLL?  The default limit is 10.  You can dynamically decrease the limit to be less than the compile time limit, but you cannot increase it beyond the maximum set when you compiled the library.

https://sqlite.org/limits.html

11. Maximum Number Of Attached Databases

The ATTACH statement is an SQLite extension that allows two or more databases to be associated to the same database connection and to operate as if they were a single database. The number of simultaneously attached databases is limited to SQLITE_MAX_ATTACHED which is set to 10 by default. The maximum number of attached databases cannot be increased above 125.

The maximum number of attached databases can be lowered at run-time using the sqlite3_limit(db,SQLITE_LIMIT_ATTACHED,size) interface.

--
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users <[hidden email]> On
>Behalf Of Keith Bertram
>Sent: Wednesday, 15 January, 2020 12:50
>To: SQLite mailing list <[hidden email]>
>Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
>
>Hello,
>
>I'm attempting to use the new SetLimitOption added to the 1.0.112 version
>of System.Data.SQLite.dll. Either I'm not using this function correctly
>or there is a problem within the dll. Any help you can provide is greatly
>appreciated.
>
>        private void Button_Click (object sender, RoutedEventArgs e)
>            {
>            int iRequestValue = 20;
>            String fName = @"d:\vancouver\OpenCommsCPV.db";
>            String connStr = String.Format("Data Source={0}, Version=3",
>fName);
>            SQLiteConnection conn = new SQLiteConnection(connStr);
>            conn.Open();
>
>            int iOldValue =
>conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED,
>iRequestValue);
>            int iNewValue =
>conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, -1);  //
>Pass -1 to get the current value.
>            if ( iNewValue != iRequestValue )
>                {
>                MessageBox.Show("Setting Num Attachments limit failed.");
>                }
>            else
>                {
>                MessageBox.Show("Setting Num Attachments limit
>succeeded.");
>                }
>            }
>
>Keith
>
>-----Original Message-----
>From: sqlite-users <[hidden email]> On
>Behalf Of Joe Mistachkin
>Sent: Thursday, October 24, 2019 8:36 AM
>To: SQLite mailing list <[hidden email]>
>Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
>
>
>Yes, the NuGet packages are included in the release.
>
>Sent from my iPhone
>
>> On Oct 24, 2019, at 9:13 AM, Keith Bertram <[hidden email]>
>wrote:
>>
>> Ok. Thanks. Does it get immediately placed under nuget?
>>
>> Keith
>>
>> -----Original Message-----
>> From: sqlite-users <[hidden email]> On
>> Behalf Of Joe Mistachkin
>> Sent: Thursday, October 24, 2019 8:12 AM
>> To: SQLite mailing list <[hidden email]>
>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>> System.Data.SQLite.dll
>>
>>
>> Within the next week or so.
>>
>> Sent from my iPhone
>>
>>> On Oct 24, 2019, at 8:37 AM, Keith Bertram <[hidden email]>
>wrote:
>>>
>>> Ok. Thanks. Do you have an estimated release date?
>>>
>>> Keith
>>>
>>> -----Original Message-----
>>> From: sqlite-users <[hidden email]> On
>>> Behalf Of Joe Mistachkin
>>> Sent: Wednesday, October 23, 2019 9:08 PM
>>> To: 'SQLite mailing list' <[hidden email]>
>>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>>> System.Data.SQLite.dll
>>>
>>>
>>> Keith Bertram wrote:
>>>>
>>>> The default limit for the number of attached databases appears to be
>>>> 10
>>> with the
>>>> 1.0.106 version of System.Data.SQLite.dll and I would like to
>>>> increase
>>> this value
>>>> to 25. I've used the sqlite3_limit function in the past to increase
>>>> this
>
>_______________________________________________
>sqlite-users mailing list
>[hidden email]
>https://urldefense.proofpoint.com/v2/url?u=http-
>3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-
>2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo
>_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=e4b8CwDAzK1-
>TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI&s=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW0X
>ea6A&e=
>_______________________________________________
>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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10.

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Keith Medcalf
Sent: Wednesday, January 15, 2020 2:54 PM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


What did you define SQLITE_MAX_ATTACHED as when you compiled the DLL?  The default limit is 10.  You can dynamically decrease the limit to be less than the compile time limit, but you cannot increase it beyond the maximum set when you compiled the library.

https://urldefense.proofpoint.com/v2/url?u=https-3A__sqlite.org_limits.html&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=msKB5Cm5_n99wUiklx4_tVTut5zWsQjh7CN1Vh4i65A&s=ibWsJ1kdTb3PI75vFiL0vv8xOusBf31qmOx3ovzgFR8&e= 

11. Maximum Number Of Attached Databases

The ATTACH statement is an SQLite extension that allows two or more databases to be associated to the same database connection and to operate as if they were a single database. The number of simultaneously attached databases is limited to SQLITE_MAX_ATTACHED which is set to 10 by default. The maximum number of attached databases cannot be increased above 125.

The maximum number of attached databases can be lowered at run-time using the sqlite3_limit(db,SQLITE_LIMIT_ATTACHED,size) interface.

--
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.

>-----Original Message-----
>From: sqlite-users <[hidden email]> On
>Behalf Of Keith Bertram
>Sent: Wednesday, 15 January, 2020 12:50
>To: SQLite mailing list <[hidden email]>
>Subject: Re: [sqlite] sqlite3_limit equivalent in
>System.Data.SQLite.dll
>
>Hello,
>
>I'm attempting to use the new SetLimitOption added to the 1.0.112
>version of System.Data.SQLite.dll. Either I'm not using this function
>correctly or there is a problem within the dll. Any help you can
>provide is greatly appreciated.
>
>        private void Button_Click (object sender, RoutedEventArgs e)
>            {
>            int iRequestValue = 20;
>            String fName = @"d:\vancouver\OpenCommsCPV.db";
>            String connStr = String.Format("Data Source={0},
>Version=3", fName);
>            SQLiteConnection conn = new SQLiteConnection(connStr);
>            conn.Open();
>
>            int iOldValue =
>conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED,
>iRequestValue);
>            int iNewValue =
>conn.SetLimitOption(SQLiteLimitOpsEnum.SQLITE_LIMIT_ATTACHED, -1);  //
>Pass -1 to get the current value.
>            if ( iNewValue != iRequestValue )
>                {
>                MessageBox.Show("Setting Num Attachments limit failed.");
>                }
>            else
>                {
>                MessageBox.Show("Setting Num Attachments limit
>succeeded.");
>                }
>            }
>
>Keith
>
>-----Original Message-----
>From: sqlite-users <[hidden email]> On
>Behalf Of Joe Mistachkin
>Sent: Thursday, October 24, 2019 8:36 AM
>To: SQLite mailing list <[hidden email]>
>Subject: Re: [sqlite] sqlite3_limit equivalent in
>System.Data.SQLite.dll
>
>
>Yes, the NuGet packages are included in the release.
>
>Sent from my iPhone
>
>> On Oct 24, 2019, at 9:13 AM, Keith Bertram
>> <[hidden email]>
>wrote:
>>
>> Ok. Thanks. Does it get immediately placed under nuget?
>>
>> Keith
>>
>> -----Original Message-----
>> From: sqlite-users <[hidden email]> On
>> Behalf Of Joe Mistachkin
>> Sent: Thursday, October 24, 2019 8:12 AM
>> To: SQLite mailing list <[hidden email]>
>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>> System.Data.SQLite.dll
>>
>>
>> Within the next week or so.
>>
>> Sent from my iPhone
>>
>>> On Oct 24, 2019, at 8:37 AM, Keith Bertram
>>> <[hidden email]>
>wrote:
>>>
>>> Ok. Thanks. Do you have an estimated release date?
>>>
>>> Keith
>>>
>>> -----Original Message-----
>>> From: sqlite-users <[hidden email]> On
>>> Behalf Of Joe Mistachkin
>>> Sent: Wednesday, October 23, 2019 9:08 PM
>>> To: 'SQLite mailing list' <[hidden email]>
>>> Subject: Re: [sqlite] sqlite3_limit equivalent in
>>> System.Data.SQLite.dll
>>>
>>>
>>> Keith Bertram wrote:
>>>>
>>>> The default limit for the number of attached databases appears to
>>>> be
>>>> 10
>>> with the
>>>> 1.0.106 version of System.Data.SQLite.dll and I would like to
>>>> increase
>>> this value
>>>> to 25. I've used the sqlite3_limit function in the past to increase
>>>> this
>
>_______________________________________________
>sqlite-users mailing list
>[hidden email]
>https://urldefense.proofpoint.com/v2/url?u=http-
>3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-
>2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90Gvh
>Oo
>_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=e4b8CwDAzK1-
>TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI&s=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW
>0X
>ea6A&e=
>_______________________________________________
>sqlite-users mailing list
>[hidden email]
>https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite
>.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_V
>nCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-
>hoNTc&m=msKB5Cm5_n99wUiklx4_tVTut5zWsQjh7CN1Vh4i65A&s=ayq9Gghb2cXi3iy5z
>qxC5qhWhMuw7o9xfoU5AwJhQwU&e=



_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=msKB5Cm5_n99wUiklx4_tVTut5zWsQjh7CN1Vh4i65A&s=ayq9Gghb2cXi3iy5zqxC5qhWhMuw7o9xfoU5AwJhQwU&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Simon Slavin-3
On 16 Jan 2020, at 3:21pm, Keith Bertram <[hidden email]> wrote:

> Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10.

The actual limit is 125.  You can set SQLITE_MAX_ATTACHED to more than 125.

It's worth explaining why you wouldn't want to attach 200 databases to the same connection.  Each time you refer to an attached database, SQLite has to search for that database in a list, meaning it has to match the schema name, then iterate through, on average, n/2 entries to find the attachment number.  The longer that list gets, the slower every operation not on 'main' or 'temp' gets.  (It's possible that SQLite hashes schema names, but I don't remember anyone ever saying that.)

I have seen posts to this list that say things like "We make one database file per day, and I want to search them all at once so I want to attach 500 files to my connection.".  It's a terrible idea and would result in slow performance.
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Simon Slavin-3
On 16 Jan 2020, at 4:19pm, Simon Slavin <[hidden email]> wrote:

> The actual limit is 125.  You can set SQLITE_MAX_ATTACHED to more than 125.

'can' should be 'can't'.  Sorry.
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
In reply to this post by Simon Slavin-3
Yes I recognize that this would be a problem. I plan on having no more than 20-25 attachments.

If I understand correctly, the only way to set the value above 10, is to recompile the source and set the SQLITE_MAX_ATTACHED variable to a number higher than my 20-25 and also below 125. I was hoping to just use the .dll straight out of nuget.

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Simon Slavin
Sent: Thursday, January 16, 2020 10:19 AM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll

On 16 Jan 2020, at 3:21pm, Keith Bertram <[hidden email]> wrote:

> Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10.

The actual limit is 125.  You can set SQLITE_MAX_ATTACHED to more than 125.

It's worth explaining why you wouldn't want to attach 200 databases to the same connection.  Each time you refer to an attached database, SQLite has to search for that database in a list, meaning it has to match the schema name, then iterate through, on average, n/2 entries to find the attachment number.  The longer that list gets, the slower every operation not on 'main' or 'temp' gets.  (It's possible that SQLite hashes schema names, but I don't remember anyone ever saying that.)

I have seen posts to this list that say things like "We make one database file per day, and I want to search them all at once so I want to attach 500 files to my connection.".  It's a terrible idea and would result in slow performance.
_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0&s=U-mtya649Yx5nGJacNeBxjNHS1gBxc2IssQUKmPwgbA&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Joe Mistachkin-3

I’ll raise the default limit for the next release of System.Data.SQLite.

Sent from my iPhone

> On Jan 16, 2020, at 2:01 PM, Keith Bertram <[hidden email]> wrote:
>
> Yes I recognize that this would be a problem. I plan on having no more than 20-25 attachments.
>
> If I understand correctly, the only way to set the value above 10, is to recompile the source and set the SQLITE_MAX_ATTACHED variable to a number higher than my 20-25 and also below 125. I was hoping to just use the .dll straight out of nuget.
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On Behalf Of Simon Slavin
> Sent: Thursday, January 16, 2020 10:19 AM
> To: SQLite mailing list <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
>
>> On 16 Jan 2020, at 3:21pm, Keith Bertram <[hidden email]> wrote:
>>
>> Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10.
>
> The actual limit is 125.  You can set SQLITE_MAX_ATTACHED to more than 125.
>
> It's worth explaining why you wouldn't want to attach 200 databases to the same connection.  Each time you refer to an attached database, SQLite has to search for that database in a list, meaning it has to match the schema name, then iterate through, on average, n/2 entries to find the attachment number.  The longer that list gets, the slower every operation not on 'main' or 'temp' gets.  (It's possible that SQLite hashes schema names, but I don't remember anyone ever saying that.)
>
> I have seen posts to this list that say things like "We make one database file per day, and I want to search them all at once so I want to attach 500 files to my connection.".  It's a terrible idea and would result in slow performance.
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0&s=U-mtya649Yx5nGJacNeBxjNHS1gBxc2IssQUKmPwgbA&e= 
> _______________________________________________
> 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: sqlite3_limit equivalent in System.Data.SQLite.dll

Keith Bertram
That would be great. Thanks!

Do you have an estimated time for this release?

Keith

-----Original Message-----
From: sqlite-users <[hidden email]> On Behalf Of Joe Mistachkin
Sent: Thursday, January 16, 2020 2:37 PM
To: SQLite mailing list <[hidden email]>
Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll


I’ll raise the default limit for the next release of System.Data.SQLite.

Sent from my iPhone

> On Jan 16, 2020, at 2:01 PM, Keith Bertram <[hidden email]> wrote:
>
> Yes I recognize that this would be a problem. I plan on having no more than 20-25 attachments.
>
> If I understand correctly, the only way to set the value above 10, is to recompile the source and set the SQLITE_MAX_ATTACHED variable to a number higher than my 20-25 and also below 125. I was hoping to just use the .dll straight out of nuget.
>
> Keith
>
> -----Original Message-----
> From: sqlite-users <[hidden email]> On
> Behalf Of Simon Slavin
> Sent: Thursday, January 16, 2020 10:19 AM
> To: SQLite mailing list <[hidden email]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in
> System.Data.SQLite.dll
>
>> On 16 Jan 2020, at 3:21pm, Keith Bertram <[hidden email]> wrote:
>>
>> Ok. I was hoping I could set the value to a value higher than 10 without compiling. I'm curious why the limit is set by default to 10.
>
> The actual limit is 125.  You can set SQLITE_MAX_ATTACHED to more than 125.
>
> It's worth explaining why you wouldn't want to attach 200 databases to
> the same connection.  Each time you refer to an attached database,
> SQLite has to search for that database in a list, meaning it has to
> match the schema name, then iterate through, on average, n/2 entries
> to find the attachment number.  The longer that list gets, the slower
> every operation not on 'main' or 'temp' gets.  (It's possible that
> SQLite hashes schema names, but I don't remember anyone ever saying
> that.)
>
> I have seen posts to this list that say things like "We make one database file per day, and I want to search them all at once so I want to attach 500 files to my connection.".  It's a terrible idea and would result in slow performance.
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit
> e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd
> _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T
> sA-hoNTc&m=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0&s=U-mtya649Yx5n
> GJacNeBxjNHS1gBxc2IssQUKmPwgbA&e=
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit
> e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd
> _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T
> sA-hoNTc&m=0j1bLQLJnI0uvx7lKmLkmB0OaagV1JNC-Uun80S1zA8&s=PNkitdI2S0362
> fPXmc4vWebzKrBumru-6krAevmX6U8&e=
>

_______________________________________________
sqlite-users mailing list
[hidden email]
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8&r=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc&m=0j1bLQLJnI0uvx7lKmLkmB0OaagV1JNC-Uun80S1zA8&s=PNkitdI2S0362fPXmc4vWebzKrBumru-6krAevmX6U8&e= 
_______________________________________________
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: sqlite3_limit equivalent in System.Data.SQLite.dll

Joe Mistachkin-3

Keith Bertram wrote:
>
> Do you have an estimated time for this release?
>

If everything goes as planned, right around the third week of February.

--
Joe Mistachkin

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