Use the links supplied at the bottom of each and every message to unsubscribe
yourself
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Dianne Dunn
Gesendet: Donnerstag, 07. Juni 2018 06:25
An: SQLite mailing list
Betreff:
Have you tried the link at the end of every message?
---
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 [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of
Hey there do you know how I can get off this list.??
Sent from my iPad
> On Jun 5, 2018, at 3:50 AM, Robert M. Münch
> wrote:
>
>> On 31 May 2018, at 19:15, Richard Hipp wrote:
>>
>> But more recently, mobile phone designers are telling me things like
>> "try to keep the size under 5
On 06/06/18 09:24, Bob Friesenhahn wrote:
> A local tool which makes it easy to configure sqlite from local files
> sounds useful ...
It already exists. It is what the SQLite team uses to produce the
amalgamations etc, and is part of the SQLite code base.
> but depending on a "web site"
sqlite3BtreeBeginTrans() now has an extra parameter. sessions do not like this.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
___
sqlite-users mailing list
I recommend a mixture of the following two solutions:
On 6 Jun 2018, at 5:05pm, Roger Binns wrote:
> That is why I advocate a web site where the user (un)ticks what they
> want, and the web site provides a correctly configured download.
6 Jun 2018, at 5:24pm, Bob Friesenhahn wrote:
> A local
On Wednesday, 6 June, 2018 10:24, Bob Friesenhahn wrote:
> The build strategy for the Python APSW extension is an
> example of unwanted dependency and loss of control.
> Building of software from source code should always be
> under the complete control of the person who is performing
> the
On Wed, 6 Jun 2018, Roger Binns wrote:
That is why I advocate a web site where the user (un)ticks what they
want, and the web site provides a correctly configured download. This
will also tell the SQLite developers what features are configured. (eg
if everyone turns off virtual tables that is
On 05/06/18 15:07, Warren Young wrote:
> All right, so include [multi-component source control and build process] ...
I'm still not sure what point you are trying to make. Yes *you* can do
that. Should *every* SQLite user who wants non-default options *have*
to go through a similar amount of
On Wed, 6 Jun 2018 14:33:12 +0300
Aydin Ozgur Yagmur escribió:
> I was applying the changes. After moving blob to last column suggested by
> Hick and eduardo, 500 MB delete took 40-45 seconds.
> I was already attempted to change page_size & cache size but i had not seen
> any significant
I was applying the changes. After moving blob to last column suggested by
Hick and eduardo, 500 MB delete took 40-45 seconds.
I was already attempted to change page_size & cache size but i had not seen
any significant improvement, so i didnt apply this now.
could you please explain positive
The structure of a record is shown in the graphic at this link which is
from my book SQLite Forensics:
www.sqliteforensics.co.uk/pics/table_leaf_format.png
As long as ALL of the serial types (i.e. all of the cell pointer array) is
held in the main B-tree (i.e. not an overflow page) which
On Wed, 6 Jun 2018 12:06:15 +0300
Aydin Ozgur Yagmur escribió:
> Thank you very quick response.
>
> We have already planned to change file system. But this problem seem not
> related with the file size, because we did not hit the limit and when i try
> to delete same data in ,for example, 2
Your schema has a major flaw that is addressed in SQLite documentation:
Do not put any fields after blob fields, especially if the content is typically
large. SQLite accesses fields in the order of defintion, so to access your
ANH_PRC_id field, it has to retrieve the 1MB ANP_VALUE blob.
Thank you very quick response.
We have already planned to change file system. But this problem seem not
related with the file size, because we did not hit the limit and when i try
to delete same data in ,for example, 2 GB-sized db, i encounter with the
same problem. This is my table and index
On Wed, Jun 06, 2018 at 09:27:57AM +0300, Aydin Ozgur Yagmur wrote:
> I have been using fat32 file system. I have a database which has 4 GB size.
Er... I'm surprised there aren't more problems due to 4GB being the max file
size supported by fat32. Any chance to change it to exFAT?
K
I have been using fat32 file system. I have a database which has 4 GB size.
Database consist of 1 parent table and 1 child table. Parent table has 10
rows and child table has 4000 rows. 1 row of child table has 1 MB size.
There are unique indexes on the tables.
When I delete a row in parent
17 matches
Mail list logo
