Dear Dolibarr Forum Users,
I am looking for a solution to reduce file size of my sql database.
It is the belief that every step counts, that has prompted me to ask this questions - “How do we delete the extra rows from the log of previous customer price on selling price for products”
I have 7 levels of customer pricing. So everytime we change something, it adds 7 rows for the SKU. I believe if we delete the top (most current) rows, it changes the price that is considered. Thus, I want to find an easy way to delete the extra rows that can be deleted from the page as well. But I have more than 3000 SKUs, so I don’t want to do it manually.
Any other ideas for reducing file size clutter is also appreciated.
Thanks in advance for your help.
Just curious how large is your database? Do you experience any issues of the application slowing down?
We use HeidiSQL to manage our MySQL database, you install it on Windows and via SSH or SSL you can connect to a remote instance. Its open source https://www.heidisql.com/
Dear @erikvanberkum,
Thank you for your response.
I have about 3 instances of Dolibarr, all in total amount to about 18gbs of Database.
My instances are not what I would call slowed down, but yes, they can be faster.
I am not from an IT Background so moving to a new db or db management software would be overwhelming. But thank you for sharing it.
Just trying to get rid of data that won’t be necessary as we move to a new financial year in India.
Any ideas on how to do that would help I guess. I have more than 266,000 rows in this table alone.
