Re: Increase sqlite3 database size

The file size of a sqlite3 database file is not a reliable indicator of
the volume of data stored in it. This is because sqlite3 does not
decrease the file size when you delete data but instead will reuse that
space on disk when you add more records. E.g., let's say you create a
database and add some records; your sqlite3 file is 100MB. Now you
delete half of your records; your sqlite3 file is 100MB. Now lets say
you add back half as many; your sqlite3 file is still 100MB. It will
stay the same size until one of two things happens: 1) you add enough
data that it has to grow the database again, or 2) you run the "vacuum"
command (http://sqlite.org/lang_vacuum.html) against the database, which
will shrink the file on disk down to the actual size of the data.

AFAIK, the only limit to sqlite3 file sizes is your available disk
space. I've used sqlite3 databases into the gigabytes with no problem.

In conclusion, I would guess that your missing entry has nothing to do
with the size of your sqlite3 file, and that the problem has nothing to
do with sqlite3.

_Nik

On 2/17/2013 6:14 PM, Hiral Shah wrote:
> Hi All,
>
> Thanks in advance for your help!
>
> I am working on back-end to fill the database tables with build
> related information. I am using Django framework with sqlite3. Somehow
> I am not able to add more data in database table after certain limit.
> I am not getting any error but database size is not increasing.
>
> For example: If I run my program, it will add entry and size is...66560
>
> If I run it with different parameter again and size it ...68608
>
> Now, how many time, I run it..it is not updating the size and when I
> try to filter particular entry , it is not there.
>
> I tried to look for size limit for database using sqlite but could not
> find anything. Please guide me if anyone ran into the same situation
> before or have any idea about it.
>
> Regards,
> Hiral
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users+unsubscribe@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.