I am designing an ASP.net webpage that will query a database as follows:
I am going to have a slider control for Width and height of a window. AS the user moves the slider I will need to query the Database to grab a design pressure and other information based on width and height. My question is, what's the best way to approach this as far as performance and reduce the amount of calls to database. It seems like a lot of overhead to query the Database every time the user moves the slider? any recommendations? should I just load the whole DB table first into some type of an array or something? I'm gonna be using vb.net as my CLI and maybe silverlight for presentation and slider..Right now the table contains about 300 records. Could probably grow to 500 or 1000
I am going to have a slider control for Width and height of a window. AS the user moves the slider I will need to query the Database to grab a design pressure and other information based on width and height. My question is, what's the best way to approach this as far as performance and reduce the amount of calls to database. It seems like a lot of overhead to query the Database every time the user moves the slider? any recommendations? should I just load the whole DB table first into some type of an array or something? I'm gonna be using vb.net as my CLI and maybe silverlight for presentation and slider..Right now the table contains about 300 records. Could probably grow to 500 or 1000
