SQL REMOTE Connection Is EXTREMELY Slow?
Jan 18, 2010
I've set up a msSQL remote connection on a GoDaddy shared hosting account (known as Direct Database Access).I'm doing some javascript/HTML/css work on the site and don't need/want to have to download/manage a separate database.The remote connection works and the pages load as expected. However, each time I request a DB driven page in my browser it takes about 2-4 minutes before the page is sent/downloaded.Could this be a limitation set by godaddy to discourage connecting to the database remotely?Is there anyway to set up a "proxy" on the production server to get the query results?Are there any alternative methods for connecting to the DB you could suggest?Should I just stop whining about it and setup a local copy of the database?
View 1 Replies
Similar Messages:
Feb 18, 2010
So i'm new to AJAX and just installed the AJAX toolkit.
When i have tried to used any of the object there my page are really slow, it like the server is forever to compile the site and when that is done the browser shows it in a flash.
You can see here :
[URL]
This is not a problem when using only ASP.NET.
When i debug in VS2008 i can see that is looking for some random files when compiling like C:AjaxBuildAjaxServerAjaxControlToolkitToolkitScriptManagerToolkitScriptManager.cs and alot of other stuff, it goes through alot of setting there and i think that is the hold up, why it's so slow.
I have Sp1 installed, running Windows 7 64bit.
These pages are very small and standard. I basicly drag a toolkitscriptmanager, htmleditor, textbox and two buttons to the form. There isnt more.
This is the code for the first page :
[Code]....
The host has AJAX support and has installed SP1 for .NET.
View 8 Replies
Nov 9, 2010
I am using AUtomapper which I am very impressed with however, I have a complex object with many nested collections. I'm using Telerik OpenAccess and it returns the 1400 records fast but when I pass it to Automapper and it slows to a ridiculous crawl. Here is my code for reference:
List<DAL.Event> query = httpContext.Events.Where(e => e.Inactive != true && e.Event_Locations != null).ToList();
Mapper.CreateMap<DAL.Event, EventDTO>();
Mapper.CreateMap<DAL.Event_Association, EventAssociationDTO>(); [code]....
View 2 Replies
Mar 22, 2010
I'm using PopupControlExtender in a GridView, which pops up various dropdowns, treeviews, calendars etc. depending on which cell is clicked. I'm populating the dropdowns on the OnPreRender event. The result is, GridView is becoming extremely slow. I've tried removing Calendar controls, the Grid is still very slow. My guess is the enormously large source view of the page, resulting from populating controls on PreRender. Here is a sample ItemTemplate:
[Code]....
My goal is to populate the controls inside popup panel only when that panel becomes visible. I tried using OnResolveControlID event for this in PopupControlExtender. But strangely enough, that event fires only when control is NOT found, contrary to what its name suggests.
Anyway, my goal is to populate the popup panels controls (mainly ListControls) ONLY when their container panel becomes visible - hoping that this will make the grid faster. The same grid works perfect with AutoGenerateColumns=true and no populating of ListControls (not an option). Also, I'm NOT using debug option in web.config.
View 4 Replies
May 5, 2010
Overall debugging works, but each step through code takes dosens of seconds.
I've already closed all additional windows like stack trace,watches,autos; deleted all breakpoints.
server and dev machine are located in different domains, so i set up local user on both, with matching password. remote debugger is running as service.
looking at security log, I found quite a lot of entries about remote debugging account logging in (record about every minute).
how i can speed up remote debugging?
dev computer: quad core, 8 Gb mem, win 7 x64 , visual studio 2010 ultimate target server: asp.net website , 2xdual core xeon, 2Gb mem, remote debugger 2010communication channel: vpn , 5 mbit , latency about 20ms. (seems that debbugging never uses more than 20 kb/s)
View 2 Replies
Feb 16, 2010
I'm trying to implement a bit of functionality that will behave much like the CustomError pages: if the connection is remote function A() will run; else function B() will run. The only problem I'm having is that I'm not sure the best way to determine a "remote" connection. Does it matter if I'm running my code on a shared web host? Can I rely on just comparing "my" IP to the request's IP?
View 1 Replies
Apr 28, 2010
I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it tests it really fast. Does anyone have any idea of what my be causing this? btw the application works fine in another computer with another database
View 2 Replies
Apr 15, 2010
iam using c#,asp.net and iis, i want to simulate slow internet connection on my pc for testing my app. is it possible i can control bandwidth of iis. System.Threading.Thread.Sleep(someDuration); in c# file.
View 3 Replies
May 25, 2010
My web app connects to my database server which is on my lan. It is usually very quick but once in a while the connection is extremely slow and has even causing errors by timing out. The server only has 1 gb of memory so I'm going to upgrade to at least 4 gb.
View 3 Replies
Dec 6, 2010
Is it possible to connect to a Remote Desktop from my ASP.net (I easily done it in .net windows application with a 4 line code and"Windows Terminal Service Control")application, If so can you guide me through it. Many thanks in advance.NB:I want to achieve it without using ActiveX control that work in IE, because with that every client would have to use IE and install the control.
View 6 Replies
Oct 31, 2010
I really don't know were to post this question, so i hope this is the right section.
I would like to create a web application that would be possible for the users to remotely connect to their desktops. In a nutshell, Web-based Remote Desktop.
View 6 Replies
Jun 16, 2010
Ok I created a web app with membership & role, intially I had 2 db but combined data with the default aspnetdb.mdf created to simplify.I then used "copy web" to move all asp files & roles folders to remote server in a sub domain directory.Created a backup of the aspnetdb.mdf and then ftp to sub domain directory which was then loaded by the host as MS SQL db name: aspnetdb3.Now, I know I need to change the web.config connection settings but to what???here is the initial connection setting:
[code]...
View 5 Replies
Apr 4, 2010
I am about to give up debugging SMTP servers to send email... My code is the following
SmtpClient mailClient = new SmtpClient("plus.smtp.mail.yahoo.com", 465);
mailClient.EnableSsl = true;
MailMessage message = new MailMessage();
message.To.Add("aditya15417@hotmail.com");
message.Subject = "permias-tucson-contact-us";
mailClient.Credentials = new NetworkCredential("myemail@yahoo.com", "mypassword");
MailAddress fromAddress = new MailAddress(Email.Text, Name.Text);
message.From = fromAddress;
mailClient.Send(message);
View 4 Replies
Aug 18, 2015
Is there any way to lunch Remote Desktop Connection from web server ?
im using code in below, it's working from my PC but it dose not working from web server.
Dim retval As Object
Dim MyIPAddress as string = "10.10.10.10"
retval = Shell("C:Windowssystem32mstsc.exe /CONSOLE /f /v: " + MyIPAddress , vbMaximizedFocus)
View 1 Replies
Aug 19, 2010
I'm getting a lot of these error messages in my logs on one of my servers and intermittently on two others.Googling didn't reveal very much information, mostly related to file uploads or downloads being interrupted. My pages are basically just text files with "ok" in them that only have .aspx extension for future plans, there's no actual code powering the pages. Servers are all Windows Server 2008 RC2 x64 running IIS7 / ASP.NET 4.Statistically it's happening well under 1% of the time but because of the volume of traffic that still clutters my event log with 2 or 3 of these messages per minute.Edit:tracked down the problem, setting buffering to true stopped it occurring.
View 2 Replies
Jun 11, 2010
I am developing an application in which I can connect to the ASPNETDB.MDF if it is on my machine, however, when I want to put it on another machine and try to remote connect it, I get the error:
An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax.
Parameter name: connectionString and my connection string is as follows:
<add name ="NewRemoteSqlServer" connectionString="Data Source=P1M1_2-HPSQLEXPRESS; AttachDBFilename=C:ASPNETDB.MDF; Integrated Security=SSPI; Username=P1M1_2-HP; Password=plus1minus1; " providerName="System.Data.SqlClient"/>
View 5 Replies
Apr 20, 2012
{"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."}
I get the above error when sending email...
View 1 Replies
Mar 9, 2010
for some reason when i view it in IE the page scrolling is extremely choppy. When i view it in firefox or safari the site is really smooth.I am not sure if i added somthing which made IE choppy because i do not remember it being choppy.... but i never really paid attention until i started to notice it.Is scrolling the site in IE choppy for you also?I tried to remove all the jquery and java - scripts i had, still choppy when scrolling. I'm not sure whats going on? The website is quite image heavy, even backgrounds are quite big, however firefox and safari have not problems... is it a IE chaching problem?
View 1 Replies
Feb 28, 2011
I have a little problem with a LinkButton in a UserControl based asp.net application. In Firefox, one single click on the LinkButton does not do anything. You have to press and hold the LinkButton for approx. 800ms to successfully trigger the PostBack.The Focus outline is lagging too. When i click on that LinkButton, the outline-change needs approximately the same amount of time you have to hold the button the trigger the postback. the webapplication and the LinkButtons are working perfectly in IE and Chrome the javascript libraries (external and internal) are currently neither obfuscated nor compressed Here's the asp.net markup:
<li id="liMemberGetPerson" runat="server" class="inactive clear">
<div class="tab clear">
<div class="tab-left"></div>
<div class="tab-main">
<asp:LinkButton ID="lbPersonArea" runat="server"
Text="Person" CausesValidation="false"
OnCommand="OnMemberViewAspectChange"
CommandArgument="MemberGetPerson" />
</div>
<div class="tab-right"></div>
</div>
</li>
Edit: the "code-behind":
protected void OnMemberViewAspectChange(Object sender, CommandEventArgs e){
AppAction currentAction = HistoryManagerFactory.GetCommandManager().GetCurrentCommand();
AppAction newAction = new AppAction();
newAction.ViewType = ViewType.MemberView;
newAction.AspectType = (AspectType)Enum.Parse(typeof(AspectType), e.CommandArgument.ToString());
newAction.ObjectID = currentAction.ObjectID;
newAction.Mode = currentAction.Mode;
HistoryManagerFactory.GetCommandManager().AddNewCommand(newAction);
ChangeAspect( newAction );}
The ChangeAspect() method call renders the corresponding View ( UserControl ). I have tried the following without success: Disable the Firefox Client Caching Disabling PartialPage Updates (disabling the UpdatePanels) If anyone has ever encountered this problem, i'd be very thankful to hear about any possible solutions.
View 3 Replies
Jan 25, 2011
I have a requirement by my client to be able to upload extremely large files.
I'm talking about 7 GB files. The website they are currently running on is a ASP.NET 4.0 app, so obviously the standard upload scheme for my web app is not going to work.
I'm tossing around multiple options trying to figure out what the best route to go would be.
One option I'm thinking about seeing if I can do would be to have a BitTorrent Uploader. The end users for this app will typically have the same file on hand, so the idea would be that an end user would go to the site, say that they wanted to upload a file. At that point, they would pick the file, and then the server would immediately mark that person as a seed for that file. Then, my web app would go to a preconfigured leech on our side, and instruct the leech to download the file. I would expect at some point during or after this process the torrent would do some magic to find other seeders on the client's network, or wherever, but that's the idea.
Is there any technology out there already that does this? Or am I describing something that I'm going to have to build from the ground up?
View 1 Replies
Sep 13, 2010
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
View 3 Replies
Mar 15, 2011
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
View 1 Replies
Jun 5, 2010
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 Replies
Jul 23, 2010
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
View 2 Replies
Apr 7, 2010
In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).
View 7 Replies