Can anyone point me to a method of achieving data stored in MS SQL or
Access from an ASP page. I want to keep six months of data available and
achieve the rest to a seperate table to maximize performance.
Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Do you mean archiving? I suggest asking in a group that focuses on the
database type you're using.
Ray at work
"Shoraz Hosein"
news:%23VbhAj0VFHA.3152@TK2MSFTNGP12.phx.gbl...
>
> Can anyone point me to a method of achieving data stored in MS SQL or
> Access from an ASP page. I want to keep six months of data available and
> achieve the rest to a seperate table to maximize performance.
> Thanks.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Do you mean "archiving"?
If so, it is just a matter of copying data from the "live" tables to the
archival tables then deleting the data from the live tables. It would
probably be best done by a scheduled batch job or stored procedure.
--
--Mark Schupp
"Shoraz Hosein"
news:%23VbhAj0VFHA.3152@TK2MSFTNGP12.phx.gbl...
>
> Can anyone point me to a method of achieving data stored in MS SQL or
> Access from an ASP page. I want to keep six months of data available and
> achieve the rest to a seperate table to maximize performance.
> Thanks.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***