search

lukasmonk / lucaschessR2

Lucas Chess R Version 2
GNU General Public License v3.0
268 stars 40 forks source link

Pack Database #25

Closed AidanMahoney73 closed 2 years ago

AidanMahoney73 commented 2 years ago

I have been playing around with the database tool and I noticed my database was getting very big (around 50gb) so I went to "pack database" to help reduce some of the size as well as removed many of the tags as I was not using them in my database anyway and after the pack, my database has jumped up to around 100gb it almost doubled in size but I have no idea why. also after doing pack database "One moment please..." stays overtop of everything permanently until I close the program entirely. I gave it multiple days and even checked task manager to confirm it was not still working it just doesn't ever go away.

lukasmonk commented 2 years ago

The file is in sqlite format. The given command is VACUUM, because it is so big it is needed a lot of space and a lot of time to do it. Maybe you should use an external program like DB Browser for sqlite, which can do the packing directly (menu Tools).

50 gb is a lot, I wasn't thinking about that size when I programmed LucasChess.