Re: 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 <[email protected]> On Behalf Of Joe Mistachkin
Sent: Thursday, January 16, 2020 2:37 PM
To: SQLite mailing list <[email protected]>
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 <[email protected]> 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 <[email protected]> On 
> Behalf Of Simon Slavin
> Sent: Thursday, January 16, 2020 10:19 AM
> To: SQLite mailing list <[email protected]>
> Subject: Re: [sqlite] sqlite3_limit equivalent in 
> System.Data.SQLite.dll
> 
>> On 16 Jan 2020, at 3:21pm, Keith Bertram <[email protected]> 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
> [email protected]
> 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
> [email protected]
> 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
[email protected]
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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users