Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

How to deal with SQL which can help me to reduce website load time?

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:93   Vote Up (0)   Vote Down (0)    

I am webmaster of eCommerce website. [Spider Office Chairs ]

I have done study of My SQL Server 2000 during my study & want to drill again in SQL.

My ultimate goal is to reduce website load time which can help me improve website performance & user friendliness.

Can any one suggest me how to I quick star with it & deal with web developer?

 

 

 

 

 

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Caputurig Back Button Event & Force The Page To Load From Server:

  
I think in many time developer need this event, which is not provided by any browser and it is not captured by any javascript event.In this Article you see how you capture this event and how you force the browser to load the page from server.

In VB.Net - how to login on a website and access another page maintaining the session

  

Have a project where I need to access a RSS feed.   The issue is this RSS feed, you need to be logged in as a user.   They have a simple web form (login + password).   How do I?

1) Post a web form with my login and password

2) Maintaining Session (w/successful login), do an additiional GET to retrieve the RSS feed.

I am doing this in an ASP.Net page so it all happens server side in VB.Net

Brian 


Modal popup panel not hiding on page load, hides on postback

  

When I browse to my page that has the modal popup panel on it, the panel initially is visable, and when I do a postback it acts as intended.  Anyone seen this?  Please let me know if you need the master page....

 

<%@ Page Title="Mystores User Management" Language="vb" AutoEventWireup="false" MasterPageFile="~/MasterPages/WanSupport.Master"
    CodeBehind="Default.aspx.vb" Inherits="WANSupport._Default5" %>

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="mainContentHolder" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div style="clear: both; width: 100%">
        <div style="width: 300px; float: left; margin-top:20px;">Users<br />
            <asp:ListBox ID="lbUserList" runat="server" CssClass="userManagementUserList" Rows="15"></asp:ListBox>
            <asp:Button ID="cmdSelectUser" runat="server" Text="Select" CssClass="userManagementButtonTop" />
            <br />
            <asp:TextBox ID="txtUserListFilter" runat="server" CssClass="userManagementUserList"></asp:TextBox>
            <asp:Button ID="cmdFilterUserList" runat="server" Text="Filter"/>
            <br />
            <br />
            <asp:Button ID="cmdAddNewUser" runat="server" Text="Create a new user" />
        </div>
        <div style="width: 600px; float: left; margin-left:20px; margin-top:20px;">
            <asp:Panel ID="pnlUserDetail" runat="server" Visible="false">
                <table class="style1">
                    <tr>
                        <td class="userManagementTableLabelRight">
                            Username</td>
                        <td style="width:200px;">
                            <asp:Label ID="lblUsername" runat="server" Text=""></asp:Label>
                        </td>
                        <td>
                            Access Groups</td>
                    </tr>
                    <tr>
                        <td class="userManagementTableLabelRight">
                            Name</td>
                        <td>
                            <asp:Label ID="lblName" runat="server" Text=""></asp:Label>
                        </td>
                        <td rowspan="9" style="vertical-align:top;">
                            <asp:ListBox ID="lbAccessGroups" runat="server" Width="150px" Rows="10"></asp:ListBox>
                            <asp:Button ID="cmdRemoveGroup" runat="server" Text="Remove" CssClass="userManagementButtonTop" />
                            <asp:ConfirmButtonExtender ID="cmdRemoveGroup_ConfirmButtonExtender" 
                                runat="server" ConfirmText="Are you sure you want to remove this access group?" 
                                Enabled="True" TargetControlID="cmdRemoveGroup">
                            </asp:ConfirmButtonExtender> 
                            <br />
                            <asp:TextBox ID="txtAddGroup" runat="server" Width="150px"></asp:TextBox>
                            <asp:Button ID="cmdAddGroup" runat="server" Text="Add" />
                        </td>
                    </tr>
                    <tr>
                        <td class="userManagementTableLabelRight">
                            Company</td>
                        <td>
                            <asp:Label ID="lblCompany" runat="server" Text=""></asp:Label>
                        </td>
                    </tr>
                    <tr>
                        <td class="userManagementTableLabelRigh 

Can't Debug Website Locally

  

Novice here.

Recently got a new (used) machine and had to reinstall VS 2008 - may or may not be related. Yesterday, I opened an existing website via Source Control. I can check files in and out and make edits, but when I try to debug locally, I get a list of errors, starting with:

"Could not load file or assembly 'System.Web.Abstractions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified."

Everyone else working on this website is able to deploy it locally. Also, if I create a new website, I can debug just fine, and I used to be able to edit and debug other sites. Everything I've found by Googling this error so far has to do with MVC projects, and suggests changing the webconfig or other files. Since other people can run this, it seems it must be a problem with my software, not the code.

Any ideas?


Can I change the default "ASP.NET Web Application" that appears every time I create a new project?

  

I'm using VS2010 and I'm trying to follow along with these videos: http://www.asp.net/general/videos and the guy in the video is using Visual Web Developer Express and when he creates a new website it's all nice and simple with a bare bones Default webpage and that's cool. Well, me in my Visual Studio 2010 when I create a new project I get this elaborate "My ASP.NET Application" page with an About page and a Login page and CSS and Jquery and it's just too, too much. Now, of course I could just create an empty ASP.NET application, but that goes too far the other way; I have to start from scratch and add the default page myself and try to reproduce exactly what the code in the video looks like and I can't really see the screen that well. Is there any way I could change my default template to what the gentleman in the video uses?


Multilanguage website

  

What is the best option or different options to create a multilingual website?

Exploit the themes?

I have three languages:

  • Three templates
  • Content in one language should link to content in the other language
  • Images are the same content, but they have different filenames (SEO)

The current website has two languages, but I want to add English ( http://www.huurvillafrankrijk.be/ )


Takes a Lot of time to execute a query

  

Dear All,


    Oracle 10g Database.

    I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.


Thanks in advance.


External ASP.NET website, need to move away from replication

  

We have an external ASP.NET website that now uses a truncated version of an Oracle database as a data store on the web and then replicates this data down to an enterprise level system on the back-end. This architecture seems to have been chosen because of certain back-end processes that need to run at night and could cause locking on certain tables needed for the web site and also as a failover mechanism in case the enterprise db goes down. 

I know there are better ways to architect this system and I am determined to get rid of the replication piece. How would you go about handling the following for your external public website.

1. eliminate locking problems during batch processing

2. fail-over for db outages



Performance difference extracting and copying in Asp.Net website with C#

  

I have almost 100 website that will update in a condition, I have a winzip archive that contains the files that replaces those websites. I want to know that

  1. I can extract that files in a folder and then copy them to all 100 websites folders
  2. I can extract the archive directly to 100 websites folders

which one is better in performance and less prone to errors


How to load "Database Instance" for "Database Trace Listener" at runtime

  

Hello,

I have been searching for a while now without success. On how when using EntLib 5.0 Logging, Data; to be able to set the database (i.e. the connection string) at runtime for a Database Trace Listener. The reason being we will have the same configurations on all levels of the environments (dev, test, stage, prod), but the connection string is different for each and we do not store the connection string data in the config file. The connection string data is loaded using a custom configuration manager for security reasons.

 

Any help and any code sample much appreciated. 

Thanks, 

Jeff


 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge