Re: [sqlite] what is the optimized way to do the vaccum?

[Gerry Snyder]

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 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 rows.
> Can I get some recommendation on what is optimized technique to do the
> vaccum for my database?
>
> Thank you,
> Liang
>

Why do you think that you need to vacuum at all?


> ___
> 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

[sqlite] what is the optimized way to do the vaccum?

[Zhu, Liang [AUTOSOL/ASSY/US]]

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 rows.  
Can I get some recommendation on what is optimized technique to do the vaccum 
for my database?

Thank you,
Liang
 
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users