# C# Sqlite data base taking too much size from Unity side

## Recommended Posts

I have integrated the sqlite data base in slot game which is build in Unity platform for windows. It is increasing drastically although it has only text data., it is showing size about 1.5 GB which is very annoying  and which will affect to my game's performance. so how can I reduce size of Sqlite database ?

##### Share on other sites

"only text data" isn't really a helpful description and text is not magically smaller than binary data, infact it can often be larger. What are you storing in your database? How do you need to query it? Can you delete some unneeded data?

##### Share on other sites
Posted (edited)

Hi SyncViews, Thanks for your answer, I just wanted to say is when we compare to large database and my database, It is vary rather than from each other and let me tell you that there are 40,000 entries in it and its taking 1.5 GB size.

Edited by Gautti

##### Share on other sites

You still need to provide more information. And "1.5" GB is nothing for many large databases, they can be terabytes or more, all depends on purpose. 1.5GB with a single table and 40,000 rows is only about 40KB per row on average, which while maybe bigger than the average row, can really be many things.

• What exactly is the schema for each table (the SQL CREATE TABLE ...  to make them)
• Provide an example of data for each table, at least 1 row
• Explain how that data is being used

##### Share on other sites
17 hours ago, SyncViews said:

s nothing for many large databases

Hi SyncViews, Actually I have done with it. My data was too long in error log. When I used vaccum, I found the bug and shorted out.

Thanks you !

## Create an account

Register a new account

• 10
• 10
• 12
• 9
• 33