eliaso76's picture
Sep 21, 2013
7601 views
Reputation: 3

How can i delete past months from database?

Tags: 

Delete old dates and months from database.

5 answers

JohnSCS's picture
JohnSCS
Sep 22, 2013
Reputation: 271

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?

eliaso76's picture
eliaso76
Sep 22, 2013
Reputation: 3

Yes, getting reports is too slow if not impossible, any idea?

Thanks.

emreeren's picture
emreeren
Sep 22, 2013
Reputation: 595

Hello eliaso76. What do you mean by slow? Is it more than 10 secs? How long are you using it? Which version?

eliaso76's picture
eliaso76
Sep 22, 2013
Reputation: 3

I am using version 2.99, much more than 10 secs, can reach to 20 mins.

emreeren's picture
emreeren
Sep 22, 2013
Reputation: 595

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

We have already answers to
1029 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634