Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please Help in archiving a database based on certain constraints

Status
Not open for further replies.

divyar

Programmer
Aug 8, 2001
1
IN
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top