hi, i am getting time out error when i execute the following query
“select MAX(PartItemID) from PartItems”
my part item table having 6 lac records
is there any other way to get the max value for this table ..please help me if u know the solution
thank u
for better response when displaying calculation large data, i suggest you adding new table to store calculated results. After you insert/update data, calculate it and store the results to the new table. When displaying data use the table.
Programming to simplify, dont look for hard way
Marked as answer by Chen Yu - MSFT on Jan 07, 2013 04:08 AM
Gajanan.Shet...
Member
262 Points
69 Posts
Time out Error
Dec 25, 2012 09:38 AM|LINK
hi, i am getting time out error when i execute the following query
“select MAX(PartItemID) from PartItems”
my part item table having 6 lac records
is there any other way to get the max value for this table ..please help me if u know the solution
thank u
+
from Pune(India)
excuse for my English am Indian.
SohailShaikh
Contributor
6119 Points
1167 Posts
Re: Time out Error
Dec 25, 2012 09:50 AM|LINK
you have to increase time for your http run time request
<location path="somefile.aspx"> <system.web> <httpRuntime executionTimeout="180"/> </system.web> </location>Sohail Shaikh
urenjoy
Star
12257 Points
1842 Posts
Re: Time out Error
Dec 25, 2012 09:51 AM|LINK
You can increase the timeout period:
http://stackoverflow.com/questions/13185981/sql-server-timeout-for-large-data-of-type-varbinarymax
OR
optimize table:
http://stackoverflow.com/questions/2831034/best-optimizing-for-a-large-sql-server-table-100-200-mil-records
oned_gk
All-Star
31563 Points
6448 Posts
Re: Time out Error
Dec 25, 2012 10:20 AM|LINK
stockcer
Member
498 Points
128 Posts
Re: Time out Error
Dec 25, 2012 06:45 PM|LINK
ASP.NET Arvixe Liaison
James River Webs, Inc.