Jump to content
  • Advertisement
Gautti

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 this post


Link to post
Share on other sites
Advertisement

"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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 !

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!