Hi ALL,
I have a problem,
I've received application written by other programmer in asp.net and was asked to speed it up.
Problem that program loads up for almost 30 seconds when it first time loading.
They and I think it's too much it supposed to take 2-3 seconds, but after my investigation most time it spends on database to generate two files header and detail to read it afterwards and loads that data into webpage by using asp.net - from point it goes to db2 and back it takes almost 28 seconds.
I need any ideas how to make it run faster, please share ideas.
I was thinking split this legacy database application into 2 one will create header and other will create detail work files and then use thread in asp.net after first page loaded run (it loads header on first page and details on second) behind the scene second part of it for details, but I never worked with threads in asp.net and do not know exactly how can I do this and would it work at all?
I need to run it silently and generate data for detail work file after first page loaded.
Any other ideas?
Thank you in advance.
I have a problem,
I've received application written by other programmer in asp.net and was asked to speed it up.
Problem that program loads up for almost 30 seconds when it first time loading.
They and I think it's too much it supposed to take 2-3 seconds, but after my investigation most time it spends on database to generate two files header and detail to read it afterwards and loads that data into webpage by using asp.net - from point it goes to db2 and back it takes almost 28 seconds.
I need any ideas how to make it run faster, please share ideas.
I was thinking split this legacy database application into 2 one will create header and other will create detail work files and then use thread in asp.net after first page loaded run (it loads header on first page and details on second) behind the scene second part of it for details, but I never worked with threads in asp.net and do not know exactly how can I do this and would it work at all?
I need to run it silently and generate data for detail work file after first page loaded.
Any other ideas?
Thank you in advance.