So far I am quite comfortable working with C# windows application. I am about to shift to Asp.net to develop a website. The requirement has made me to put around 50 columns in a single table. I know this concept of breaking it into small tables using normal forms.
I tried googling, but dint get much results. I need to know if my table with 50 attributes would decrease performance of my web application?
Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer return rowsaffected > 0;//since function returns a bool On the slow machine this line of code takes a few milliseconds.One the fast machine it takes 5 seconds.These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
I am using the following XML structure
<SERVERS>
<SERVER NAME="A1" ID="1"></SERVER>
<SERVER NAME="A2"></SERVER>
<SERVER NAME="A3" ID="3" Parent="XYZ"></SERVER>
<SERVER NAME="A4" ID="4"></SERVER>
<SERVER NAME="A5" Parent="abc" value="10"></SERVER>
<SERVER NAME="A6"></SERVER>
</SERVERS>
I am accessing this xml file by using LINQ to XML in asp.net by using C#. I am able to access all the attributes of an XML node by explicitly specifying the name of the attribute. I want to write query on this xml file which reads all the attribute values of the xml node (In our example the node is SERVER) dynamically means I want to write the query which can read the read the value of the attribute Name & ID from first node, only name from second row, Name, ID & Parent from the third row , Name & ID from the fourth row, Name, Parent & Value from the fifth row & only Name from the sixth row without modifying the existing code every time. Once I add one of the attribute ( for example if I add the attribute ID in the sixth row ) in the above xml file then I dont need to modify my LINQ to XML query. My query should dynamically fetch the total number of attributes & display their values. Is their any way to do this ?
i just create table simply like this: create table tblDemo
(
PK_intID int primary key identify(1,1),
intHits int not null
[code]...
I have one Store Procedure that generating report ..
For storing the data there , i used many temp. tables. There is many Select Query , little less insert and delete query.
Now if there is huge data around 1 lac in temp table my select query taking to much time and also may be insert and delete query
I added Primary key to all auto Increment Field in temp table. Also defined Clustered index on that primary key as unique Clustered index to improve the performance .
But there is not so much improvement in case of huge temp table.
Right now the whole Store Procedure is taking time to complete around 1.5 days or around 30 hours ..
So i want to increase the performance as much that it completes on nearly 3-4 hours.
I have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 RepliesI have the line where is goes "Hide Suggested budget with tolerance %' then the box is too large. It is almost fine, you can see here
[URL]
The box holding the '5' for the Tolerance percent is too large. How can I reduce this?
the code for all this area is here:
[URL]
This is the IF -Else ladder which I have created to focus first visible control on my form.According to the requirement any control can be hidden on the form.So i had to find first visible control and focus it.
if (ddlTranscriptionMethod.Visible)
{
ddlTranscriptionMethod.Focus();
[code]...
I am using asyncfileupload ajax control and can successfully upload and save picture on server.I need to do the following and not sure how:When user is in process of uploading, I only want them to see *.jpg *.gif and *.bmp files
Once the user uploads their picture, how do I reduce the quality of the picture so it is less than 10 KB?
I have two lines of labels each in a Horizontal StackPanel. When they display there is a wide space (about an inch) between them. I can't figure out how to reduce this spacing. The height characteristics does not seem to do it.
<UserControl x:Class="SilverlightApplication1.MainPage"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480" Margin="10">
<StackPanel x:Name="LayoutRoot" Background="LightGray" Margin="10">
<StackPanel Orientation="Horizontal" Height="50" Width="500" Margin="10">
<TextBlock Height="15" Width="100" Margin="20"/>
<TextBlock Text="Heading" Height="15" Width="100" Margin="10"/>
<TextBlock Text="PDOF" Height="15" Width="100" Margin="15"/>
<TextBlock Text="PDOF" Height="15" Width="100" Margin="15"/>
</StackPanel>
<StackPanel Orientation="Horizontal" Height="50" Width="500" Margin="10">
<TextBlock Height="15" Width="100" Margin="20"/>
<TextBlock Text="(degrees)" Height="15" Width="60" Margin="10"/>
<TextBlock Text="locked" Height="15" Width="40" Margin="10"/>
<TextBlock Text="(degrees)" Height="15" Width="100" Margin="15"/>
<TextBlock Text="(O'Clock)" Height="15" Width="100" Margin="15"/>
</StackPanel>
</StackPanel>
</UserControl>
I am using Javascript for my ascx control. I have 2 tables, one below the other. My code written is like
</tr>
</table>
<table style="border-spacing: 15px;">
But when i execute, it shows almost 2 inch space between them.
I have an application that allows users to upload a pdf. I am saving the PDF into SQL (I know already this is not the best practice, but it was not my decision) and I need to some how duing this upload process reduce the size of the pdf. Is there a way to get the uploaded file, reduce its size, then stream it to SQL?
View 12 RepliesI have a problem of image loading. My site contains around 20 images on home page. It will take to much time to load.
So is there any code in asp.net framework 3.5 that will reduce the load time without jquery or javascript.
I have a variable called "Totaltime" in my program. I assign the variable (in seconds) as Totaltime = 3600. Now i want to reduce the time by 1 sec for each Tick event and show the reducing time in label or litera control. tell the C# ASP.NET coding to implement this?
View 3 RepliesI have a web application project on my dev PC running WinXP and hence IIS 5.1. The changes I'm making to this site seem to "take effect" only after I do IISRESET. That is, I make a source change, Rebuild the project and then Start without Debugging (or with debugging). The newly changed code is not "visible" or in effect unless I intervene with an IISRESET.
BTW, the "web" tab on the Properties display for the web app project is configured to use the Local IIS web server at project Url: http://localhost/myVirtualDirectory
...
but I've noticed the same issue when using the VStudio Dev Server (i.e. I have to stop it by visiting the taskbar tray area in order to see my source changes take effect).
Is this something I can change?
EDIT UPDATE:
Just wanting to clear this up if possible. Two answers diverge below; not sure how to move forward. One states this is to be expected (weakness of IIS 5.1 which in turn is the best WinXP can provide). Another states this is not expected behavior (and I tend to agree since this is the first I've encounted this on the same old WinXP dev platform I've had a long time). I suspect it may be something "deep inside" the Visual Studio 2008 web app which was upgraded to this new IDE from VStudio 2002 (ASP.NET 1.1). I've tried to add comment/questions down each answer path.
[Code]....
Is there any other way to make this more efficient?
I am facing a problem related to webpage loading. After analysing the problem I got the conclusion that this is because of the use of third party control (Telrik Control) on the page.
it loads "ScriptResource.axd?d=VHFRlHPU4ruHmOYm-mEPLk5XeFL0XZCCksSiaq9cH120I4XzMjzdvS3A-Z1Q4FSlJuGkXycxn8tvOxEGZvni7w2&t=634068427680000000"
type of scripts on browser so it take time to load the page. Is there any way to reduce time of loading page?
SELECT t1.Assign as [User Id],(t2.Name)as [Name],
View 5 RepliesIf you use a space <br /> this is a little too much space.Is it possible to reduce the interval between two textbox?
View 6 RepliesI have Gridview inside div and i achieved the gridview scroll with the div. but i am struggling with reducing the space between gridview and scroll bar. below is my code and screen print also attached.
Code:
<div id="divGrid">
<div style="overflow-x: auto; width: 800px; height:360px;">
<asp:GridView ID="gvReport" runat="server" AutoGenerateColumns="true" EnableViewState="false"
AllowSorting="false" EmptyDataText="No Data." AllowPaging="false" PageSize="50"
ShowFooter="false" GridLines="Both">
[code]...
i used baloon popup extender to show alerts but how to reduce its height is aa problem.i have less text in panel to display.so lot of empty space come.
View 1 RepliesI need to do parallel processing in my coding because i have 4 sql to fetch data from database which each take me 3-4 minutes.All the tables involved are raw table and that is no way i can reduce the time for the sql.I need to find a way out to reduce the data fetching time.The only thing i canfigure out is to have this 4 sql execute at the same time by doing parallel processing.
View 4 RepliesI'm looking for ways to reduce the size of my page . I have a page that just renders a gridview - no images - and it is over 400k!
Looking at the html that is generated I see the names of the controls in the gridview are very very long. For example: ctl00_ContentPlaceHolder1_releaseGV_ctl149_lblBuy
My gridview is about 200 rows by 13 columns = ~ 2600 spans with very long names rendered. The above example is 49 characters X 2600 controls = 127,400 characters just in control ID's!
The actual data on my page ins't anywhere near a tenth of that!
I am already storing viewstate on the server.
YES, I will put a pager on this page to bring down the number of rows. Also, I've seen sever other posts related to page size with some excellent content. I will follow up on them - however I have not seen this specific question answered.
Here is a sample of my page. As you can see there is not much data and a lot of html!
[Code]....