|
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
|
|
|
|
|
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 ???
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
How to create a setup for web application
|
|
|
|
|
|
Hi All,
I am working in Web Development Firm. We have client name MSN India. When ever anyone open in.msn.com page from all over the world three banners are loading on the every page. Some of them are serving from our Richmedia server. Msn tracking how many times our banner runs on MSN Portal and we also the same thing. But the report is showing different no. Normally when any banner(Flash) running on msn it is calling our one page name getbase.aspx we are simply inserting into one temporary table. After some specific interval we are running job which will check the detail and find the location and update or insert into the master table from where we are generating reports. Our DB Admin is telling our DB server has capacity to open 42k connection / 1Sec. And when any one banner is running on high priority then it will send 150 to 200 request / 1sec. Then also we are not getting same reports due to timeout expired. Is there any other possible way to reduce the load on db server? So we can stop timeout? It’s very urgent. If any sample code can you put it will be acceptable.
<a href="http://www.tardak.com">http://www.tardak.com</a>
|
|
|
|
|
Hi,
Can u pls help me on the below questions. This questions were asked in some exams. I want to clarify the doubts. I am not asking the answers during writing exams.
1) Is Client-side validation done by default?
a) no
b) yes
c) modified by user.
2) Which control displays static text?
a) Label.
b) Literal.
c) Both
d) none.
Tnx.
With Regards,
Anand
modified on Monday, February 23, 2009 3:34 AM
|
|
|
|
|
anandhakrishnan wrote:
1) Is Client-side validation done by default?
a) no
b) yes
c)modified by user.
What are you talking about ? Its Important to be sure what you ask before you ask
anandhakrishnan wrote:
2) Which control displays static text?
a) Label.
b) Literal.
c) Both
d) none
What is this, are you writting some kind of a quiz and you are posting it here for help. We dont allow this here. If you dont know , buy a book.
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
|
|
|
|
|
You managed to post this from a job interview, or it's homework ? Either way, the answers would not help you if I gave them. Try reading a book and learning some basics.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
I have a datalist which has a label in the template header. The label's visibility is false initially.
After that I have the ItemTemplate
It contains a label for a date which has visible = false initially
after that I have a linkbutton for a category name.
So when the page loads it will list categories vertically header = false, date= false.
Each category is click able.
When the user clicks on a category the category name will show in the header. The label's visibility in the header is set to true. Below it will be the subcategories. The label for sub category date visibility = true and the link button is replaced with clickable sub categories instead of the main categories.
How can I achieve this functionality?
I would appreciate as many details as possible to achieve this.
Thank you for reading.
<asp:DataList CssClass="VideosDatalist" OnItemDataBound="bindDL" ID="VideosDL" runat="server">
<HeaderTemplate>
<asp:Label ID="lblVideoHeader" Text='<%# Eval("categoryName") %>' runat="server" Visible="false"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblVidDate" runat="server" visible="false"></asp:Label><br />
<asp:LinkButton ID="lnkBtnCategory" OnCommand="VideosLink_Command" CommandName='<%# Eval("categoryName") %>' CommandArgument='<%# Eval("categoryID")%>' runat="server" CssClass="VideosDatalistLinks"
Text='<%# Eval("categoryName") %>' NavigateUrl="~/videos.aspx"></asp:LinkButton>
<div style="padding-top:20px;"></div>
</ItemTemplate>
</asp:DataList>
|
|
|
|
|
I want to install visual studio 2008 in my laptop which is in Window vista
OS, from where can i get the installation CD,is it available in net as free download software could be trial version.
Many Thanks,
Arpita
|
|
|
|
|
Arpita27 wrote: I want to install visual studio 2008 in my laptop which is in Window vista
OS, from where can i get the installation CD,is it available in net as free download software could be trial version.
Does it anything related with ASP.NET ? First read the forum guideline before post.
Anyway, you can download it from here[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi,
I have a DropDownList and a ajax UpdatePanel which having MultiView with 3 View inside the MultiView.
When i select any list from the DropDownList, different view will appear.
If i set ddl_price.SelectedItem.Value; from the code-behind, the UpdatePanel will not work because in html source code, the DropDownList will write "selected".
Is there anyway to not write "selected" in html when ddl_price.SelectedItem.Value; assigned? Or is there anyway to make the ajax UpdatePanel works?
Pls help.
Thx.
|
|
|
|
|
If you only access the views through their index, the best way to do it would be :
private void ddl_priceSelectedIndexChanged(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex=ddl_price.SelectedIndex;
}
Obviously, if there is some conditioning involved, as in string comparison or value comparison, you haev to include that logic before you change the ActiveViewIndex.
Also, just a reminder, remember to set the UpdatePanel's update mode to "Conditional".
Regards,
G.
var question = (_2b || !(_2b));
|
|
|
|
|
so i have a page that will have 6 [input type='file' id='unique'] controls on it and i want to process them efficiently
in my c# code behind i have something like
protected HtmlInputFile theFile;
where "theFile" is the ID of one of the [input type='file'] controls ... i'm assuming the connection is wired up automatically as it seems to work
my question is do i need a separate
protected HtmlInputFile theFile1;
protected HtmlInputFile theFile2;
protected HtmlInputFile theFile3;
protected HtmlInputFile theFile4;
protected HtmlInputFile theFile5;
protected HtmlInputFile theFile6;
for each control or is there a way of using one and looping through the controls?
thnx and i hope i explained that ok
"mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them"
|
|
|
|
|
|
roguemat wrote: Hope that helps
It won't help me right now, but still an interesting piece of code to bookmark 
|
|
|
|
|
You need seperate controls - you need to render 6 file controls, so you need 6 controls to handle them. You CAN loop through the forms control collection looking for input controls if you like, rather than explicitly dealing with each one, that way you can change the number of controls on the form at any time and it will just work.
foreach(Control control in this.Controls)
{
HtmlnputFile file = control as HtmlInputFile;
if (file != null)
{
// process
}
}
Now, I believe for this to work, it needs to be done recursively.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi
i have placed database inside App_data Folder
and connection string inside Web.config
<connectionStrings >
<add name="conString" connectionString="Data Source=localhost;database=pubs;AttachDbFileName=|DataDirectory-|\pubs.MDF;uid=sa;pwd=server"/>
</connectionStrings>
and iam using MS sql server 2000 database as beckend
iam getting the following error
Invalid value for key 'attachdbfilename'.
at below line
SqlConnection cn = new SqlConnection(ConnectionString);
can any body guide me what iam doing wrong .
Best wishes
Rameez
|
|
|
|
|
AttachDBFilename=|DataDirectory|pubs.mdf" providerName="System.Data.SqlClient"
try this
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
