Configuration :: Adapter.Update (table) Fast On Development Machine, But Very Slow On Server?
Oct 17, 2010
Using VisualWebDeveloper 2010 on the development machine. All nice and fast.Using VisualWebDeveloper 2008 on the server. Server runs on Windows Server 2008 and has IIS 7.
It looks like that when 'table', a datatabe filled up in C# code behind, is getting longer, then the server (whether running the website on IIS or on the local host of VIsualWebDeveloper2008) is really slowing down. Checked it in debug mode and traced it down to
Adapter.Update(table);
Are there any know issues? Could it be that there is incompatibility between different version of SQL server or something like that? The update works, it is just awefully slow, but only on the server.
View 2 Replies
Similar Messages:
Jan 29, 2010
I know it's not the best practice to do, but unfortunately I created a page with multiple large dropdown lists and have them inside an ajax updatepanel. I found some work arounds using siderite's ajax updatepanel adapter:
http://fastlistadapter.codeplex.com/.
The performance is very good while I am debugging on my machine, but when I publish the site and post it to a win 2003 server the performance drops off almost as bad as when the fix isn't there.
I understand that using a 3rd party fix really isn't supported by most, but is there any obvious reason why debug performance would be much better than published site performance on the same exact code?
View 2 Replies
Aug 31, 2010
I am using table adapter in a dataset type (.xsd) file mapping to database. But I found after I created a new stored procedure in database and use table adapter mapping to the new stored procedure, I got method not found error like
Method not found: 'PO_GetNewOrdersSummaryDataTable BizTalk.Application.DataAccess.DatalayerTableAdapters.PO_GetNewOrdersSummaryTableAdapter.GetDataByCompletedDays(System.String, System.String, System.Nullable`1<Boolean>, System.Nullable`1<Boolean>, System.Nullable`1<Int32>)'.
on the testing server. But it is fine if I run the web application on my local dev machine and another machine we use it for building application before deployment. Does anyone know what could cause this problem on testing server? It works fine before I created the new method
GetDataByCompletedDays in PO_GetNewOrdersSummaryTableAdapter.
View 3 Replies
Nov 2, 2010
what i have is the following code.
[code]...
View 2 Replies
Apr 25, 2010
Debugging using the ASP.NET Development server is extremely slow to initialize. The behavior I'm getting is that if I launch the DevServer from VS2008, the first attempt to load a page takes minutes. After that, it's fine. Before the first page load, the DevServer UI responds to input normally (I can bring it up from the status area, use its context menu, and move the window around) until the first page load comes in. Then it shows the busy cursor (spinning blue ring) for 2-6 minutes before finally completing. There is no significant processor or I/O activity during this. After that, it runs normal speed, quite fast.
View 2 Replies
Jul 18, 2010
I am trying to add "Select Scope_Identity()" to my table adapter but vs2010 respond with "Unable to parse query text." error message.
Code for Insert SQL is -
INSERT INTO orders
(creditAutorizarionNumber, OrderName, OrderPersonPhone, OrderPersonEmail)
VALUES (@creditAutorizarionNumber,@OrderName,@OrderPersonPhone,@OrderPersonEmail)
I tried to add -
;Select Scope_Identity()
How can I use the Scope_Identity() withing a BLL table adapter ?
View 2 Replies
Feb 17, 2010
I have used CKEditor in my ASP.NET pages. But after than, that pages are very slow. Is it possible that it is caused by CKEditor?
View 1 Replies
Jul 30, 2010
when I access any page of my ASP.NET MVC website first time, then this first request is slow. It needs about 4-5 seconds to load. But every following request to any page is fast.When I wait some minutes or a hour then every first request is slow again. Every following request is fast.
I think that IIS 7 is compiling the code and keep it in memory. After some time it will delete it from memory so it needs to compile it again.What can I do that every first request is as fast as every following request?
(Without precompiling my source, if possible)
View 3 Replies
Nov 23, 2010
Microsoft recommends testing older versions of IE with the following virtual machinesThis is all fine and good, except that the virtual machines can't see the Dev Server from Visual Studio. This makes it very difficult to develop or debug since I have to copy or deploy to IIS for every little change I make. I've tried using ARR, but it seems it can only forward to one specific port at a time, whereas i need to have the port typed in the address bar of the virtual machine to match the port that it is connecting to on the host machine. Is this possible?
View 3 Replies
Aug 11, 2010
I have made an asp.net web application using VS 2008 to show crystal reports. I have used CrystalReportViewer control to show reports.
The table (sql server 2005 ) from which I have to fetch data has approximately 400000 records. I connect to it using OLEDB ( Microsoft OLEDB provider for sql server )
I have wrote the following code to achieve this :
[code]....
View 1 Replies
Dec 7, 2010
Just like in title. It works much faster on IE (8, 9) than on firefox and chrome ?How is it possible ?
Whats more I had to disable cookies on aspxGridViews because I had bad requests all the time,
View 1 Replies
Oct 29, 2010
When I run my piece of SQL through SQL developer it takes less than half a second with an overall cost of 618 on the explain plan.
When I run the same SQL through .NET via the oracle.dataaccess.client connection it is impossibly slow taking over 5 minutes to run.
What could be causing this and what can I do?
View 7 Replies
Feb 24, 2011
We recently migrated to v4 of .net. We are running iis 7 in integrated mode. When the site first starts its slow. I get that - it compiles for the first time. The odd thing is then we will go to certain pages and it seems to compile again. The next time i go that page its very fast. Nothing exceptional with the second page - but once that is hit the rest of the site is fast.
View 1 Replies
Jan 15, 2010
[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
View 1 Replies
May 11, 2010
Let's say you set maxRequestLength to the max number (2097151) (units are KB) and use the following code for your OnClick event for your submit button:
int int fileSize = FileUpload1.PostedFile.ContentLength;
if (fileSize < 2000000)//units are bytes
Label1.Text="too big";
else
{
FileUpload1.SaveAs(saveItHerePath);
Label1.Text = "Upload success.";
}
Why when a huge file is attempted does it take a minute to get to the OnClick event on the server? Because if maxRequestLength were set to that value 2000, it would immediately choke if you tried to upload a 500MB file. What is going on here? What are the best practices for using the FileUpload control? Is there a better alternative way of uploading or checking for file size?
View 5 Replies
Jun 10, 2010
I'm having a strange problem - probably has a simple answer but, I haven't been able to find it or figure out the cause. I'm hoping someone has had this same problem and figured it out.
Basically - my application works great on the development machine. So I copy it over to the server and it works great. Come back the next day and my GridView is only displaying the first record...I then log into the server remotely and open the web page on the server and all records are returned, so the application works fine on the server. I then return to the local machine and now the application is returning all rows in the GridView. So, weird but, what whatever, it works. Go away and come back again the next day and...
1 ) Only 1 record from dataset is displayed in GridView
2 ) Log onto server remotely and view webpage on server --> all records now display
3 ) Try again on local machine, now application works fine...grr. What am I doing wrong here? Using Visual Web Developer 2008 on Windows XP. Querying SQL Server 2000 (I know, I should switch to 2005 and use VWD 2010 - but ouch, really!) when a text box value changes (Vendor_PO_TextBox.TextChanged)
[Code]....
View 1 Replies
Jun 16, 2010
I have two applications(A,B) both are developed in .NET3.5 and used LDAP services.Application-A in one screen we are fetching users with role "project Leads" and it is taking 10 min time
Application-B in login screen we are checking user is authenticated or not and it is taking 20 sec
Both the applications are using the same service then way there is a time span problem. Please suggest me what can I do to improve performance of application A?
View 3 Replies
May 22, 2010
I am using the asp.net 3.5. i have development a website using master page, user control, update panel, asp.net ajax such as loading box and message box etc. when i testing the site in my local, it show with the normal speed. but after i upload the website into the live server, the loading box and message box is slow loading.if there is a popup of messagebox, it is slower and when i click the ok button on the message box. it seem close in very slow and have a duplicate box come out. i have no idea on it. why it is so slow when uploaded to the server?
View 1 Replies
Aug 16, 2010
I have developed a web application in asp.net with c# with out using master page. I have developed this application in iframe.
The problem is that my application run smoothly but suddenly it stops and do some processing and it run again smoothly.
it stops any where on page load, on button click, on checkbox changed. i can not tell where it stops
it stops only when page post. i can see the processbar on browser's statusbar it stop for long time 40 to 60 seconds and after that i fire same event now process complets within 2 to 5 seconds
Hosting server detail :
1. IIS 6.0
2. Window server 2003.
3. Sql server 2005.
View 4 Replies
Mar 22, 2010
I am wondering the best way to change my connection string based upon which server I am accessing.
Essentially, all of the development is done on our local machines - once we think it is working, we upload it to our development server. In these 2 instances, I want my application to go off of our "dev" connection string for the SQL database in the web.config.
However, once it is published to our production server (for an internal application), I would like the connection string to point to our live db.
I am using the N-Tier model by Imar Spaanjaars - and have it setup like he suggests - In my DAL I have a class called AppConfiguration -
In this class I have a public readonly property ConnectionString() which returns the connection string in the web.config.
This is in an individual class library. What I would like to do is something similar to:
If server is localhost OR devstring return devString else return productionstring
View 1 Replies
May 11, 2010
I am a problem in my one of my web applications. I run this application under ASP.NET Development Server. Normally, in all of my other projects, when I made a change, I recompiled the project, and then press CTRL+F5 in the browser, then the new changes will be displayed in the browser. However, this specific project, when I made a change, recompiled, and then press CTRL+F5 in the browser, the page stayed the same as it was, withouth displaying the changes. I have to restart the ASP.NET Development Server to see the new changes.
This problem is not only happending in my PC, but also in others who doesn't have Visual Studio installed. So I guess there is nothing to do with my PC's environment. Are there anything wrong with my web.config?
View 2 Replies
Jan 17, 2011
im Developing a site since a very long time,Using a remote database Connection.Previously site in local machine runs fast.But now a days even login takes morethan a min (in Local) but on hosting it runs as fast as it was
View 1 Replies
Jun 17, 2010
I never host any web application on the development server.I learn the tutorial how to copy the file using file zilla FTP client.But question is raised, how can I link my sql server machine to Http development server.And how can I configure my database on the development server.What at all DNS setting is require?
Finally All I need is , upload a web application and SQL server database on development server.
View 1 Replies
Dec 5, 2010
I created the simplest MVC project with Visual Studio 10, and it works fine on the VS Development Server, but won't run using IIS on the same computer under IIS (Windows Server 2008 R2 with ASP.NET 4.0.30319).
My steps were:
File / New / Project ...Visual C# / Web / ASP.NET MVC 2 Web Application... and kept the default name: MvcApplication1
Clicked Debug to build and run ... the default page appears fine at http://localhost:49175 ...
Then I closed that browser and clicked on MvcApplication1 / Properties / Web and selected "Use Local IIS Web server"Clicked "Create" to create the virtual directory at http://localhost/MvcApplication1
Clicked Debug again... and got HTTP Error 403.14 (Web Server configured to not list directory)
It seems that IIS cannot find a Default document. If I add a document to the virtual directory (C:inetpubwwwrootMvcApplication1) with one of the default doc names, that document will display OK.
Why can ASP.NET find the default document (Views/Home/Index.aspx) when running from the VS Development Server, but not when running from IIS??
I have tried running "aspnet_regiis -i", but still find that C:inetpubwwwrootaspnet_clientsystem_web4_0_30319 is an empty folder. Should there be something here?I have tried giving all sorts of permissions to the virtual directory folder (C:inetpubwwwrootMvcApplication1) but without any success.
View 4 Replies
Jul 23, 2010
With the project I'm working right now, the team and I don't believe the network/computer policies will allow us to create and save Excel files on a local machine through the Web pages we're building. Well, let me clarify. When we run our web pages on our development machines, when we go to save information to excel through the web page, it uses our local excel executable. However, we want it to use the web server's excel executable. When we run the website, we're running individual local copies because we don't have a web server to test on, so we can't verify if it will use the Web Server's or ours. Does anyone know what it will do, or if it has to be programmatically set a specific way to use excel on the web server, and not on the local machine. Once we get the Web Server to use excel, we'd save the file to a network share that would allow the user to view the file.
View 2 Replies
