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+unsubscr...@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+unsubscr...@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.
