asp.net2.0 that runs store procedure in back end. [modified]
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???? :)
modified on Monday, February 23, 2009 4:07 AM
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???? :)
modified on Monday, February 23, 2009 4:07 AM
Hi, First you should specify which type of query u executed in stored procedure, like as retreive more than 2000 records from ur query. so it will take so much time
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???? :)
modified on Monday, February 23, 2009 4:07 AM
actually your page expires out... It would be better to create a separate process that may run your stored procedure, if you dont need any result from it... You can also use WCF for doing this ... if you need.
Abhishek Sur
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???? :)
modified on Monday, February 23, 2009 4:07 AM
What Exactly is your SP doing if it takes this long? To have an infinite timeout Option set your Command object to zero. You need to Optimize your sp. "A call for SP optimization, is a result of bad design from the begining"
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???? :)
modified on Monday, February 23, 2009 4:07 AM
Your stored proc sucks. Fix it. We have a SQL forum. You think the timeout is the issue ? No-one is waiting 30 min for a web page.
Christian Graus Driven to the arms of OSX by Vista.
-
actually your page expires out... It would be better to create a separate process that may run your stored procedure, if you dont need any result from it... You can also use WCF for doing this ... if you need.
Abhishek Sur
u r absolute Ok can u give some idea or links about how to create separate process to execute such a store procedure by using MFC. Advance thanx for interest in it.
-
What Exactly is your SP doing if it takes this long? To have an infinite timeout Option set your Command object to zero. You need to Optimize your sp. "A call for SP optimization, is a result of bad design from the begining"
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???
-
Advance thanx for ur interest in it. my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000". but the problem is not fixed. Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not. My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website. i dont want to wait for such much time, until the execution of my query,i just want to execute it. any idea on this ???
Really that is too heavy for a Web page. Does your users interact with your page? ,or this is some admin thing that you do it at certain time ? . If that's the case,I suggest you create an SSIS package and leave the web page out of this. Lets here what the other guys say.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za