How to handle the cache and datasets??

[plenderj]

In relation to postbacks, you can use a simple piece of code:

Sub Page_Load( ... )
    If Not IsPostBack Then
        
    End If
End Sub

So. Just do the SQL stuff once, store into the cache, and then that's that.


In relation to storing user preferences, there are lots of ways of doing it. How are users selecting parameters, by tickboxes on forms or textboxes or what?

[MrNorth]

Yeah I already knew about the postback, thanks I don't think its what I need to solve my performance problem.. I will dig further... Have just spent 2 hours reading through tons of msdn articles on the subject... sessionstate, viewstate, cache tips and tricks


Anyway, second problem... About remembering viewstate between calls... the first solution that comes into mind is to store the control indexes in the cache along wiht control ID... but is it the best way?? So if it isn't a postback, check the cache for the selectedindexes and textbox texts...

Or perhaps there is a way to dump the entire viewstate of an object to cache?? not just the properties... Perhaps a performance hit, but the quickest way to do it

cya
Henrik

[nemaroller]

Well, the search criteria could not be that big correct?

I mean - you have a few true/falses, number ranges perhaps, or a few strings?

You can save those parameters into viewstate - or if you're worried about context, have you looked into attaching that information in to a cookie?