sqlite database memory issue

Question

I am trying minimize the memory usage of my sqlite database. Originally, in my Android application, the db was about 400kb, as everything worked fine. The db copied easily from the assets folder for first time users. We had to change some things about the database, and it is now about 850kb. The db does not copy from the assets folder to a device(it works on an emulator). In the new, larger db, I tried changing some of the columns that were text columns into integers and reals(when possible). This did nothing to reduce the size. Any ideas?

Thanks!

Femaref · Accepted Answer · 2011-10-11 14:42:15Z

4

The Vacuum command might help. It recreates the database from scratch, eliminating fragmentation and other things bloating your database.

answered Oct 11, 2011 at 14:42

Femaref

61.5k8 gold badges145 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coder Over a year ago

Yes! That took off 400kb! Thanks.

Adnan · Accepted Answer · 2012-02-18 12:29:50Z

1

In SQLite once you create a database an certain amount of memory is used. As you keep on increasing the memory it takes from the stack. But it does not free this memory, as its an feature of the SQLite to retain this memory for future use. Use Vaccum to free this memory.

answered Feb 18, 2012 at 12:29

Adnan

111 bronze badge

Collectives™ on Stack Overflow

sqlite database memory issue

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related