Dear friends,
sub:
----
Please Help in archiving a database based on certain constraints
We have a product that has a the follwing architecture,
"web part 1 - admin - web part 2"
the admin section controls both web parts.
now we have a database grown in size.
we have some uploading and downloading features in the webpart and some searching features from the database.
The web part timesout when a user searches for some thing from my database.
so to prevent it, we want to archive the old data that will not be used frequently, but based on certain constraints like, if some part of the data is not searched or if it is old one that cannot be used then we have to remove those records either,
1.automatically
2. or based on the constraints we will be giving like names starting with letter 's'.
i want this data not be removed permanently but should be put in some tables in the same database or in some other database and when ever the admin part user wants to work with the old data we have to allow it.
If any one has the idea or used it please send it to me contact me at, ( if u have further clarifications also )
"kannanr@salliemaesolutions.soft.net"
or
"msc_kannan@yahoo.com"
Thanks.
R.Kannan.
sub:
----
Please Help in archiving a database based on certain constraints
We have a product that has a the follwing architecture,
"web part 1 - admin - web part 2"
the admin section controls both web parts.
now we have a database grown in size.
we have some uploading and downloading features in the webpart and some searching features from the database.
The web part timesout when a user searches for some thing from my database.
so to prevent it, we want to archive the old data that will not be used frequently, but based on certain constraints like, if some part of the data is not searched or if it is old one that cannot be used then we have to remove those records either,
1.automatically
2. or based on the constraints we will be giving like names starting with letter 's'.
i want this data not be removed permanently but should be put in some tables in the same database or in some other database and when ever the admin part user wants to work with the old data we have to allow it.
If any one has the idea or used it please send it to me contact me at, ( if u have further clarifications also )
"kannanr@salliemaesolutions.soft.net"
or
"msc_kannan@yahoo.com"
Thanks.
R.Kannan.