Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
Assuming no blocking issues, the release should be out by the first week of March at the latest. The changes have been made to permit the limits to be changed and the default attached database limit has been increased to 30. Sent from my iPhone > On Feb 24, 2020, at 9:34 AM, Keith Bertram wrote: > > Hi Joe, > > Do you have an ETA on the new build? > > Also I wanted to confirm the change to the variable that would allow me to > set the number of attachments to a number higher than 10. I would like to set > it to 25. > > Keith > > -Original Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: Saturday, January 18, 2020 6:29 PM > To: 'SQLite mailing list' > Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll > > > 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 > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=R-68Cs5Fb8R4NqTy8Z_KN392QyIGPkeK5wUAbjuM2nE=Xr8F673ynyjKjjWcb0AImOWopT_ajZZTSmFqcw6DAdg= > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
Hi Joe, Do you have an ETA on the new build? Also I wanted to confirm the change to the variable that would allow me to set the number of attachments to a number higher than 10. I would like to set it to 25. Keith -Original Message- From: sqlite-users On Behalf Of Joe Mistachkin Sent: Saturday, January 18, 2020 6:29 PM To: 'SQLite mailing list' Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll 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 sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=R-68Cs5Fb8R4NqTy8Z_KN392QyIGPkeK5wUAbjuM2nE=Xr8F673ynyjKjjWcb0AImOWopT_ajZZTSmFqcw6DAdg= ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
That would be great. Thanks! Do you have an estimated time for this release? Keith -Original Message- From: sqlite-users On Behalf Of Joe Mistachkin Sent: Thursday, January 16, 2020 2:37 PM To: SQLite mailing list 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 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 On > Behalf Of Simon Slavin > Sent: Thursday, January 16, 2020 10:19 AM > To: SQLite mailing list > Subject: Re: [sqlite] sqlite3_limit equivalent in > System.Data.SQLite.dll > >> On 16 Jan 2020, at 3:21pm, Keith Bertram 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 > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit > e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd > _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T > sA-hoNTc=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0=U-mtya649Yx5n > GJacNeBxjNHS1gBxc2IssQUKmPwgbA= > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit > e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd > _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T > sA-hoNTc=0j1bLQLJnI0uvx7lKmLkmB0OaagV1JNC-Uun80S1zA8=PNkitdI2S0362 > fPXmc4vWebzKrBumru-6krAevmX6U8= > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=0j1bLQLJnI0uvx7lKmLkmB0OaagV1JNC-Uun80S1zA8=PNkitdI2S0362fPXmc4vWebzKrBumru-6krAevmX6U8= ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 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 On Behalf > Of Simon Slavin > Sent: Thursday, January 16, 2020 10:19 AM > To: SQLite mailing list > Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll > >> On 16 Jan 2020, at 3:21pm, Keith Bertram 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 > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0=U-mtya649Yx5nGJacNeBxjNHS1gBxc2IssQUKmPwgbA= > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
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 On Behalf Of Simon Slavin Sent: Thursday, January 16, 2020 10:19 AM To: SQLite mailing list Subject: Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll On 16 Jan 2020, at 3:21pm, Keith Bertram 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 sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=UbVOkNIBY7TVyWQB9v2LK-xBIWk_rpXp5sXbzOFNwr0=U-mtya649Yx5nGJacNeBxjNHS1gBxc2IssQUKmPwgbA= ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
On 16 Jan 2020, at 4:19pm, Simon Slavin 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
On 16 Jan 2020, at 3:21pm, Keith Bertram 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
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 On Behalf Of
Keith Medcalf
Sent: Wednesday, January 15, 2020 2:54 PM
To: SQLite mailing list
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=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=msKB5Cm5_n99wUiklx4_tVTut5zWsQjh7CN1Vh4i65A=ibWsJ1kdTb3PI75vFiL0vv8xOusBf31qmOx3ovzgFR8=
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 On
>Behalf Of Keith Bertram
>Sent: Wednesday, 15 January, 2020 12:50
>To: SQLite mailing list
>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 On
>Behalf Of Joe Mistachkin
>Sent: Thursday, October 24, 2019 8:36 AM
>To: SQLite mailing list
>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
>>
>wrote:
>>
>> Ok. Thanks. Does it get immediately placed under nuget?
>>
>> Keith
>>
>> -Original Message-
>> From: sqlite-users On
>> Behalf Of Joe Mistachkin
>> Sent: Thursday, October 24, 2019 8:12 AM
>> To: SQLite mailing list
>> 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
>>>
>wrote:
>>>
>>> Ok. Thanks. Do you have an estimated release date?
>>>
>>> Keith
>>>
>>> -Original Message-
>>> From: sqlite-users On
>>> Behalf Of Joe Mistachkin
>>> Sent: Wednesday, October 23, 2019 9:08 PM
>>> To: 'SQLite mailing list'
>>> 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
>>>
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://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 On
>Behalf Of Keith Bertram
>Sent: Wednesday, 15 January, 2020 12:50
>To: SQLite mailing list
>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 On
>Behalf Of Joe Mistachkin
>Sent: Thursday, October 24, 2019 8:36 AM
>To: SQLite mailing list
>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
>wrote:
>>
>> Ok. Thanks. Does it get immediately placed under nuget?
>>
>> Keith
>>
>> -Original Message-
>> From: sqlite-users On
>> Behalf Of Joe Mistachkin
>> Sent: Thursday, October 24, 2019 8:12 AM
>> To: SQLite mailing list
>> 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
>wrote:
>>>
>>> Ok. Thanks. Do you have an estimated release date?
>>>
>>> Keith
>>>
>>> -Original Message-
>>> From: sqlite-users On
>>> Behalf Of Joe Mistachkin
>>> Sent: Wednesday, October 23, 2019 9:08 PM
>>> To: 'SQLite mailing list'
>>> 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
>sqlite-users@mailinglists.sqlite.org
>https://urldefense.proofpoint.com/v2/url?u=http-
>3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-
>2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo
>_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=e4b8CwDAzK1-
>TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW0X
>ea6A=
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 On Behalf Of
Joe Mistachkin
Sent: Thursday, October 24, 2019 8:36 AM
To: SQLite mailing list
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 wrote:
>
> Ok. Thanks. Does it get immediately placed under nuget?
>
> Keith
>
> -Original Message-
> From: sqlite-users On
> Behalf Of Joe Mistachkin
> Sent: Thursday, October 24, 2019 8:12 AM
> To: SQLite mailing list
> 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 wrote:
>>
>> Ok. Thanks. Do you have an estimated release date?
>>
>> Keith
>>
>> -Original Message-
>> From: sqlite-users On
>> Behalf Of Joe Mistachkin
>> Sent: Wednesday, October 23, 2019 9:08 PM
>> To: 'SQLite mailing list'
>> 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
sqlite-users@mailinglists.sqlite.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=e4b8CwDAzK1-TKWOZZJxjXuHFSnDxxfXP6h5QVKBpaI=dOVM934ewvnS0gL9iui_PzN0keYUOjW48CiQW0Xea6A=
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 wrote: > > Ok. Thanks. Does it get immediately placed under nuget? > > Keith > > -Original Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: Thursday, October 24, 2019 8:12 AM > To: SQLite mailing list > 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 wrote: >> >> Ok. Thanks. Do you have an estimated release date? >> >> Keith >> >> -Original Message- >> From: sqlite-users On >> Behalf Of Joe Mistachkin >> Sent: Wednesday, October 23, 2019 9:08 PM >> To: 'SQLite mailing list' >> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
Ok. Thanks. Does it get immediately placed under nuget? Keith -Original Message- From: sqlite-users On Behalf Of Joe Mistachkin Sent: Thursday, October 24, 2019 8:12 AM To: SQLite mailing list 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 wrote: > > Ok. Thanks. Do you have an estimated release date? > > Keith > > -Original Message- > From: sqlite-users On > Behalf Of Joe Mistachkin > Sent: Wednesday, October 23, 2019 9:08 PM > To: 'SQLite mailing list' > 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 > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit > e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd > _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T > sA-hoNTc=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk=sCLCkHRvR-ztd > vVVSGxqaiz1a_tcrqNlHTio4zORCuE= > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlit > e.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd > _VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4T > sA-hoNTc=ToaKjNz0BYd7qdR5qRjM5upVh5PLjdoYkQe5hWOHkGQ=MRsMclki0g0JT > pTyrcS2EvjvvP5z5dOAS2yXbUYta8c= > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=ToaKjNz0BYd7qdR5qRjM5upVh5PLjdoYkQe5hWOHkGQ=MRsMclki0g0JTpTyrcS2EvjvvP5z5dOAS2yXbUYta8c= ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 wrote: > > Ok. Thanks. Do you have an estimated release date? > > Keith > > -Original Message- > From: sqlite-users On Behalf > Of Joe Mistachkin > Sent: Wednesday, October 23, 2019 9:08 PM > To: 'SQLite mailing list' > 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 > sqlite-users@mailinglists.sqlite.org > https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk=sCLCkHRvR-ztdvVVSGxqaiz1a_tcrqNlHTio4zORCuE= > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3_limit equivalent in System.Data.SQLite.dll
Ok. Thanks. Do you have an estimated release date? Keith -Original Message- From: sqlite-users On Behalf Of Joe Mistachkin Sent: Wednesday, October 23, 2019 9:08 PM To: 'SQLite mailing list' 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 sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers=DwIGaQ=hmGTLOph1qd_VnCqj81HzEWkDaxmYdIWRBdoFggzhj8=l90GvhOo_5uKc2d8JIuoVtb0fH4diec3z4TsA-hoNTc=m2M1vgITLsaAq32oeWR3t3BL5zfQYJkiHqNZ17uZtSk=sCLCkHRvR-ztdvVVSGxqaiz1a_tcrqNlHTio4zORCuE= ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
