[ASP.NET & VB]

[WildARMs]

Hi guys I have a question. I'm working on a website using asp.net and vb. I want to put a graph on the front page that updates everytime the page is refreshed. I looked into crystal reports, but Im a bit worried. I need to have make the website as if there may be a large load on it at some point. I dont think it would be good to be hitting that database so many times.

Does anyone have any suggestions? I thought maybe a text file with the data might work.

Any suggestions would be greatly appreciated! Thanks!

[Dav-id]

use ajax

[Dav-id]

edit: sorry double post

[WildARMs]

So, I could use it to update the graph every time the page is reloaded? Or even on the fly while the page isnt being loaded?

I'll give it a look, thanks for the suggestion!

[mattbta]

  whoreman said:

use ajax

What is ajax going to do for him? He's worried about hitting the db too many times.

[azcodemonkey]

  WildARMs said:

Hi guys I have a question. I'm working on a website using asp.net and vb. I want to put a graph on the front page that updates everytime the page is refreshed. I looked into crystal reports, but Im a bit worried. I need to have make the website as if there may be a large load on it at some point. I dont think it would be good to be hitting that database so many times.

Does anyone have any suggestions? I thought maybe a text file with the data might work.

Any suggestions would be greatly appreciated! Thanks!

Does the data the graph represents change a lot? If not, use the global cache object to cache the DataSet. In ASP.NET 2.0, you can set a database dependency on the cache, so when the database updates, the cache is invalidated and refreshed. Rebind the graph to the cached dataset on each new page load(a.k.a. Not Page.IsPostBack = True). If you're not using 2.0, you'll have to set a timed dependency on the cache to refresh it.

It may behoove you to enable ViewState on the graph so you don't rebind on every postback. If the graph is heavy and viewstate isn't an option, then rebinding on each postback should be cheap using the cached data.

[WildARMs]

Ok, I'll give that a try, thanks.

Im not sure how often the database will be updated. In reality, not very often. For developement purposes though we need to make it as efficient as possible.