Hello,
I have an application which keeps an index of data in an SQLite
database. I'm trying to figure out the best way to handle the possible
scenario of database filling out the entire hard disk. I could just
delete some of the oldest rows, but I wonder if it's possible that even
delete
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Antti Nietosvaara
Sent: 25 November 2009 09:41
To: sqlite-users@sqlite.org
Subject: [sqlite] Running out of space
Hello,
I have an application which keeps an index of data in an SQLite
database. I'm trying to figure out the best way
On 25 Nov 2009, at 9:40am, Antti Nietosvaara wrote:
I have an application which keeps an index of data in an SQLite
database. I'm trying to figure out the best way to handle the possible
scenario of database filling out the entire hard disk. I could just
delete some of the oldest rows,
On 11/25/09 10:50 , Simon Slavin slav...@bigfraud.org wrote:
The message is that if you are short of
space it is already too late for any software to cope with the problem.
I disagree. It all depends on where you set the threshold for short of
space. To give you a trivial example, if I set
Simon Slavin wrote:
I assume your database file is on your boot volume. What operating system
are you using ?
Actually the database is alone in its own partition. I'm currently
trying to avoid the problem by assigning big enough partition for the
db calculated from the estimated data
On 25 Nov 2009, at 12:26pm, Antti Nietosvaara wrote:
Simon Slavin wrote:
I assume your database file is on your boot volume. What operating system
are you using ?
Actually the database is alone in its own partition.
Ah. That's better in some ways. But I think you're still better off