anticipated traffic volume.
>-Original Message-
>From: sqlite-users On
>Behalf Of Aydin Ozgur Yagmur
>Sent: Thursday, 31 October, 2019 05:40
>To: SQLite mailing list
>Subject: Re: [sqlite] Multiple files for a single SQLite database
>
>How can it be raised to
Oh, I found the answer.
SQLITE_MAX_ATTACH should be changed.
On Thu, Oct 31, 2019 at 2:40 PM Aydin Ozgur Yagmur
wrote:
> How can it be raised to 125?
> I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED,
> 125)" but there is no effect.
> I still get "too many attached
On Oct 31, 2019, at 5:40 AM, Aydin Ozgur Yagmur wrote:
>
> How can it be raised to 125?
Define SQLITE_MAX_ATTACHED at build time:
https://www.sqlite.org/limits.html#max_attached
> I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED,
> 125)" but there is no effect.
How can it be raised to 125?
I tried to change with calling "sqlite3_limit(db_, SQLITE_LIMIT_ATTACHED,
125)" but there is no effect.
I still get "too many attached databases" exception.
On Wed, Oct 30, 2019 at 5:01 PM David Raymond
wrote:
> "There's a limit, somewhere around ten, I think.
On October 30, 2019 9:58:20 a.m. EDT, Simon Slavin wrote:
>There are things you cannot split across different database files. For
>instance, you cannot declare a FOREIGN KEY that refers to a table in a
>different schema. Because SQLite can't be sure you'll have that schema
>available.
It's
"There's a limit, somewhere around ten, I think. Though you can increase it by
explicitly messing with limits and compilation options."
Default is 10, can be raised to 125.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
On 30 Oct 2019, at 1:41pm, Aydin Ozgur Yagmur wrote:
> SQLite stores a single database in a single file.
>
> According to the specific project requirements and due to the performance
> concerns;
>
> When working with large databases, is it possible to explicitly tell SQLite
> not to store
SQLite stores a single database in a single file.
According to the specific project requirements and due to the performance
concerns;
When working with large databases, is it possible to explicitly tell SQLite
not to store the whole DB in a single file and store different tables in
different
8 matches
Mail list logo