I am having a weired problem with my infragistics. Here is my scenario, I have a dash board with 10 charts in it for each county/ states in US and this whole page calls 10 stored procs to display data, so it takes about 14 seconds to load data and display the page [out of that 13 seconds for sp's] and the data wont change for a month or so. So I updated the deployment scenario to ImageURL="ChartImages/Chart_#SEQNUM(1000).png" and also I set the @OutPut cache of the page to 5 days [60*60*24*5]. Everything used to work fine till last week. I used to observe ChartImages folder and I can see image number ranging from 0 to 999. But suddenly from yesterday I can see only images from 0 to 111. Since the pages are cached for 5 days it displays wrong charts for my selection criteria's.
Hopefully I explaind my problem correctly. ANY HELP
I think for your case is better to try using the built-in ASP.NET caching. More about this you can find:
Thanks for your response. Yeah... I am using ASP.NET built in caching for cahing my pages. So I feel that is not the issue. I have been using ASP.NET from last 8 years, I am pretty sure that it is not ASP.NET. As I said, I used to see images in ChartImages folder from 0.png to 999.png. All of a sudden it stopped working. Now I can see only images from 0 to 111.png. Since my asp.net pages are cached like 600 pages , I assumed that it caches the chart images also, but it is not, I think infragistics points to ChartImages folder, and it has only 111 images to display. so the same graph is getting used on other pages but that graph does not belong to that page.
I am not able to explain in proper terms,
Page1.aspx has Chart1, chart2 to....... chart10
Page2.aspx - Chart11
Page3.aspx - Chart12
All the above 3 pages are cahed by using @OutPutCache vary by param *, so for each set of query string the page is cached. Initialy even the graphs used cache but now it wont. So on Page1.aspx I can see Chart12
hmm... that is an interesting solutio. Anyway... I decided not to make use of cache and other craps. Now the whole site is pretty straight forward. I removed caching, I removed ChartImage(1000).png and defaulted o 100 [which is by default. In the sense, I created a new web site from scratch. Now I having a different problem I can see other users graph on my page. How to solve that, I might be missing very basic thing here. I postedmy issue in this thread http://forums.infragistics.com/forums/t/11657.aspx
With @OutPutCache vary by param *, you just catch the HTML output for every query. So this is not related to the way of deployment the chart. Also I'm not sure why the chart images from your ChartImages folder disappear, but you can try deploying every chart in different folder.
Thanks for the quick response, I have an answer for that also. I am using SQLite for local data caching, for the first time when user hits it takes 14 seconds, Once I get the data I cache that data locally using SQLite and it is superfast so now the page no longer need to wait 14 seconds but I wanna make it still fast [thats what my manager wants] so I decieded why to create the graph every time so I increased the chart image cache number from 100 (which is default) to 1000. From there problem started coming :( and also I did @output cache. ( may be I am too greedy, theoritically all these sounds right to me but why it is not working )
Raghu