|
If we have any calls longer than about a second we tend to hand them off to another process in SQL.
The Webservice submits the request to SQL which stores the request, we then use SQL Service Broker to trigger processing of that request, which is then on another SQL thread and independent of the webservice which has long since returned. For really long SQL jobs (over 20 seconds) we have a scheduled job pick up the stored request for processing.
If your webservice call takes longer than a few seconds you are using the wrong technology.
Having said that, we once had a task that processed over 16 million financial transactions and ran for several weeks. Migrating to SQL (it was FoxPro) brought it down to hours, and fixing the crap SQL brought it down to under a minute. So the problem may be in the processing not the technology.
|
|
|
|
|
Well dont get me started on this...
The amount of WTFs in this code is enough to fill thedailywtf for a few weeks... (It was made by an external consult that have programming skills below what I have after 3 years of school)
But im almost certain there is a wrong technology in use here. The site is using a ORM tool that have been put in over the webservice as well. I have previously considerd to remake the entire webservice to not use the ORM tool (that is really database heavy) and instead go directly to the database but havent got around to it yet.
There is no doubt that it takes to long to process but since its still posible to do it during the night the ppl prioritising the assignment just dont think it important how long it takes (It processes around 20 items each min so its not "that" slow. Its just there is alot of items).
Best Regards
HE
|
|
|
|
|
So 3 Seconds an item, via a web service. That consultant should be taken out and shot.
I think your safest bet would be to post a handful of items at a time then. Don't even attempt to throw the lot over in one shot. And forget the threading, unless its only purpose is to keep a progress indicator ticking.
Oh, a final thought. Pepper your code with comments along the /* this is terrible but I have no choice */ style so any future developer is forewarned to run away fast.
|
|
|
|
|
Shooting is to good a punishment for him... we need something more evil not sure what thou... (Did I mention that I started with a webservice that took around 10 sec. an item...)
And well Ill try talking with them if we could limit the amount of items. The threaded way actually works like it should and helps make it not time out (great improvement from a webservice that timed out when it had moved some data but not all)
I will try to see what we can come up with. And well im handing it over to a programmer that have been sitting next to me for the last 5 months he knows how crappy it is... maybe I should just let him have a look at it as an introduction to the system... so that he dont have his hopes to high when he comes to the crappy parts...
And its more giving to just write
everywhere something is crappy
Best Regards
HE
|
|
|
|
|
Hi All,
I was facing a issue in IE8 - When I open second/third level pop-up window and closes it then it opens on new page.I solved the issue.But I did tested it on IIS 5.1..When I deployed it on server having IIS6 then it reflected the same POP-UP issue again.
Any Help will be helpful...
|
|
|
|
|
How are your opening your pop-up window? If it is through javascript, it may not have to to anything with the version of IIS you are using. Show us a code as to how your are opening your pop-up window.
Also, mind you some browsers can be set up to open popup windows in new window. check your browser setting.
|
|
|
|
|
function fnOpenModalScreen(URL,WindowObj,Features)
{
window.showModalDialog(URL,WindowObj,Features)
}
|
|
|
|
|
Havent tested it in IE8 (For some reason the company here only wants IE7 compability) But try using
window.open(URL, windowName[, windowFeatures]) instead that might work.
if you just want to see if it can open just add
window.open(URL)
Best Regards
HE
|
|
|
|
|
I dont want to open a new window.My requirement is to open a new POP-UP on button click and then on closing that POPUP the parent page(having that button)will refresh.But the error is that on closing/any button click on the POPUP, POPUP open in new window/browser..
|
|
|
|
|
The ones who can help you the best ignore URGENT PLZZZZ posts
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Well, I can name at least two people who didn't!
|
|
|
|
|
I said ones who can help most. Mine is not helpful to problem
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Can you post some simple case code that demonstrates the problem?
|
|
|
|
|
SomeDomain/AddLineup.aspx?&Cname=Yogesh&Contact1=NA&Contact2=NA&DataCenter=NA&Distt=NA&Activity=NA&School=NA&ActivityDate=NA&ALocation=NA&VisitTime=NA&DateVisit=NA&VisitCenter=NA&CourseInt=NA&Comments=NA&TransferBy=NA
Hi i want to call a url like i mention above. Its working fine when i run the same through debug.
But when i upload the same on my webserver it give me the error.
System.NullReferenceException: Object reference not set to an instance of an object. at AddLineup.InsertRecordLinedUp()
Here InsertReceordLinedUp is a function in AddLineup.aspx page.
Plz Reply.
Thanks
Yogesh Agarwal
|
|
|
|
|
That means you are referencing an object in InsertRecordLineUp , which you have in your development machine but it does not exist in your webserver.
|
|
|
|
|
|
Why posting at multiple forums? You did in Q&A. Stick to that.
|
|
|
|
|
i want to check my broswer
so i want this fuction to execute just one or little time.
but This code don't stop reading page.
below is source
//////////////////////////////////////////////////////
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>회원조회 페이지</title>
<script type="text/javascript" src="/BrowserCheck.js"></script>
<script type="text/javascript">
function a()
{
document.getElementById("txt_broswer").value =
document.getElementById("txtSubject").value = " koko ";
form1.submit();
}
//check_Select();
</script>
</head>
<body style="text-align:center" onclick="a()">
<form id="form1" method="post" action="Default.aspx" >
<input type="text" id="txtSubject" name="txtSubject" value="test" />
<asp:Label ID="Label1" runat="server" Text="Label" ></asp:Label><br />
<input type="hidden" id="txt_broswer" name="txt_broswer" value="test" "/><br />
</form>
</body>
</html>
///////////////////////////////////////////////////
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string jung = Request.Form["txtSubject"];
Label1.Text = "returnvalue1 " + jung;
return;
}//if postback
}
hi
My english is a little.
anyway, nice to meet you~~
and give me your advice anytime~
|
|
|
|
|
buffering83 wrote: this fuction to execute just one or little time
Which function? What do you mean 'little time'
buffering83 wrote: but This code don't stop reading page.
What do you mean?
also, format, format, format the source code you post here
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
The relevant code must be in BrowserCheck.js. Can we see that please? But only if you put it in a code block so we can read it.
|
|
|
|
|
Hi guys am trying close the browser window once user clicks button 'Exit browser',
in asp.net
I tried the following but it won't work
string scriptor = "<script type=javascript>window.close();</script>";
if(!ClientScript.IsStartupScriptRegistered("clientScript"))
{
ClientScript.RegisterStartupScript(Page.GetType(), "clientScript", scriptor);
}
and
Response.Write("<script type=text/javascript>self.close()</script>");
this is in my click event
Does anyone know how i can fix this one?
please help
|
|
|
|
|
What happens if you add an 'onclick' attribute to your button as set is equal to window.close();
Seems a bit unnecssary to require a postback to the server for this.
|
|
|
|
|
Try this:
string script = "window.close();";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "CloseWindow", script, true);
This should work.
|
|
|
|
|
Hi thanks Sandeep,
Well, this works for IE but unfortunately it won't work for Fire Fox
for some reason...
|
|
|
|
|
Respected
How we Import ExcelSheetData into SqlServer2005 Table,by using Asp.net with C# .
Thanks.
|
|
|
|