SQL Data base

[Balaji_DP]

Hello NI,

                     i am using database toolkit and sql server 2005... my application has to insert 50 channels of termocouple data with the interval of 1 min, and the process will go on continuosly...

my question is that our customers need a graph display as well as data table display... is it possible to show the data graph as well as data string as table...

for one day will have around 500 or 800 rows of 50 channels....

will it manage the PC memory for doing this task?..

if its not possible then, how can i manage?

suggesstion please.

[JK1 · Accepted solution]

Hi,

When there is a need to display huge amount of data...one approach is to display data on demand by user. 

Keep updating the table with latest 100 rows and when user wants previous history populate the table with previous history of data.  By providing comfortable user interface user will not feel it as a burden.

Hope this helps.

[Balaji_DP]

Thanks JK,

                     I already done the same application without graph display... that was very successful and satisfied our customers...

hope this tooo will successfull..

thanks again