Yes you are right, that's actually what I am trying to decide. What to do I have so many options, to archive or not to partition or not there are certainly adv and disadv to all approches and as said by Bore "Both will work" but taking a decision is something which not can have economic impact but also about future maintainance, for example I am not sure if the existing data is partitioned will it impact the current code or not? I mean there are so many questions that certainly comes with experience.
Thanks to all.

Habeeb