According to the SQLlite.org, the purpose of vacuum is as follows,
VACUUM command rebuilds the database file, repacking it into a minimal amount
of disk space.
I am trying to resolving an issue, I am keeping the record count in each row
for the table with 20 row, After the table fill up
, at 6:31pm, Zhu, Liang [AUTOSOL/ASSY/US]
wrote:
> If I do not do Vacuum, my database size just keep raising, eventually the
> database size gets to over 90% of storage size, I can save data to the
> database any more.
VACUUM should not be saving you any space. And VACUUM p
:12 AM
To: SQLite mailing list
Subject: [EXTERNAL] Re: [sqlite] what is the optimized way to do the vaccum?
On Wed, Dec 4, 2019, 9:28 PM Zhu, Liang [AUTOSOL/ASSY/US] <
liang@emerson.com> wrote:
> All Sqlite Expert,
>
> I have one table, I am inserting and deleting rec
All Sqlite Expert,
I have one table, I am inserting and deleting record to and from this table
very 250ms. I always maintain 1000 rows in this table. I have another table,
I am inserting and deleting data to and from this table every 1s. The data
record in this table maintains at 200,000
] how to delete BLOB object from the data base
On 15.07.19 21:38, Zhu, Liang [AUTOSOL/ASSY/US] wrote:
> ... I am inserting to the BLOB data into the table at every 250ms, I
> delete the oldest row at every 600ms, also I am reading the data from
> the database at every 10ms...
How do you
Sqlite Experts,
I have a table contains the BLOB object, I am inserting to the BLOB data into
the table at every 250ms, I delete the oldest row at every 600ms, also I am
reading the data from the database at every 10ms. After almost of 100,000
insert, delete and select operations, I am
questions
are: What is the planned _transaction_ rate? And how many different connections
will be trying to write at once?
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Zhu, Liang [AUTOSOL/ASSY/US]
Sent: Friday, May 03, 2019 10:01
Hi Sqlite experts,
In my current project, we have the need to inserting and deleting data to and
from the database between 1 and 10 ms for 24/7. I am seeking the
clarification on the following questions
1. what is the throughput requirements are possible using Sqlite API?, in
other
8 matches
Mail list logo