Monday, March 26, 2012

Ring buffer for Real-Time data

Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansenConsider using a partitioned view. When you need to add more data, create a
new table and alter the view. When you want to purge a large chunk alter
the view to exclude the table that has the chunk, then drop the table. The
BOL talks about partitioned views.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Hansen" <ehansen940@.hotmail.com> wrote in message
news:809ff900.0410220459.561bd2f9@.posting.google.com...
Hello
Can anybody help me with strategies for implementing a Ring Buffer for
Real-Time Data?
My application inserts real-time data (at a very heavy rate) and I
need to replace/delete old data on regular basis. If not the disk will
eventually be filled up...
brgds
EHansen

No comments:

Post a Comment