October 11, 2002 at 12:09 am
Sire,
A table consisting of 20 fields (all nvarchar), is being continuosly populated.
To eloborate : This table collects polling data.
Now, reporting has to be done, where data source is this table.
No. of records in table > 800000
per second atleast 8 records gets appended.
How should I acheive a on line accurate reporting mechanism using this table ?
Any workaround ? apart from automated periodic purging of the table ?
Sucess ..
Sanjev verma
What ever a Human can imagine , it can be achieved !!
What ever a Human can imagine , it can be achieved !!
October 11, 2002 at 3:54 am
When you ask
quote:
How should I acheive a on line accurate reporting mechanism using this table ?Any workaround ? apart from automated periodic purging of the table ?
What portion of the data needs to be reported on while appending is going on, and have you run into issues? Also, when doing a select from that data have you tried using the (NOLOCK) hint? 800000 records is not that extreme so not sure what issue other than blocking you may run into. There are all kinds of potential tricks I just need to you to elaborate more please.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
December 13, 2002 at 8:03 pm
When you say online do you mean you are displaying the table in the web using ASP?
The you should refresh the page usint a metatag to refresh every minute or so.
If not, you can create an activex component and use a trigger to communicate with it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply