Last post Oct 28, 2010 02:07 PM by raindrop12
Oct 22, 2010 03:47 PM|raindrop12|LINK
I need to do lengthy processing (getting data in to 3 different temp files) for final report.
I have SQL script ready and it works on SQL Studio however, same query from ASP get timeout error.
I am looking for some ideas on how to handle and make this work. Where can I place this processing?
Oct 24, 2010 09:04 PM|bobj181|LINK
How are you getting that data into the temp files and what is your error?
Oct 25, 2010 11:42 AM|raindrop12|LINK
I am getting data by combining data from three tables in temp1 table. Then I am applying soem calucilations (mostly gropu by)to make temp2 table. The DB I am quering is slow so overall query execution does take about 2 minute.
From ASP page, same query gives me time out error.
Oct 25, 2010 09:18 PM|bobj181|LINK
I suggest you step back and take a good look at your system, it's design, and the requirements. First, you do not need to combine data into a temp table, try using a select statement with joins, probably one of the reasons that the Server is running slow
is because it is running out of RAM Memory so it has to resort to Hard Memory in the processing of data (This will causing the a machine to run slow). Calulations do take up some costs, but if they are nessecary, then they cannot be avoid. As to the database
being slow, unless the box is under powered, i.e. not enough memory to meet the suggested operating requirments, the slowness is due to performance tuning. Depending on the DB that you are using, you can use tuning tools to see where you can make the database
As to the timeouts, the DB is not responding back to the webserver quick enough. You can up the timeout time period, but look at you DB first.
Oct 28, 2010 02:07 PM|raindrop12|LINK
Sorry for late response on this, here are multiple issues
1. Hardware is old and slow
2. I am using joins
3. We are checking data into three different DB so that explains processing cost. I have no say on existing design. That is the way it is. I need to figure out solution for my work.
What I am looking is a way to break this processing in a way (using SqlDataSource) so that I can display the result in chart.