Delete old dates and months from database.
You can delete old data via a database tool, but it will not be easy, and you run the risk of damage to the database.
Is there any specific reason for removing the data?
Yes, getting reports is too slow if not impossible, any idea?
Thanks.
Hello eliaso76. What do you mean by slow? Is it more than 10 secs? How long are you using it? Which version?
I am using version 2.99, much more than 10 secs, can reach to 20 mins.
If you are using sdf database please consider switching to sql database because sdf database does not support some important indexing features. If you already switched to sql from sdf check this topic.
http://forum2.sambapos.org/index.php/topic,1394.msg6539.html#msg6539
5 answers
You can delete old data via a database tool, but it will not be easy, and you run the risk of damage to the database.
Is there any specific reason for removing the data?
Yes, getting reports is too slow if not impossible, any idea?
Thanks.
Hello eliaso76. What do you mean by slow? Is it more than 10 secs? How long are you using it? Which version?
I am using version 2.99, much more than 10 secs, can reach to 20 mins.
If you are using sdf database please consider switching to sql database because sdf database does not support some important indexing features. If you already switched to sql from sdf check this topic.
http://forum2.sambapos.org/index.php/topic,1394.msg6539.html#msg6539