Click here to Skip to main content
15,890,527 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i build a Web Application for School in VB.net with sql server,offline its working perfect but when i host on any server its working very slow,
when i click on any form its start uploading and its takes time.

What I have tried:

need help in vb.net with sql server website running very slow

Here is my Connection String
<?xml version="1.0"?>
<!-- 
    Note: As an alternative to hand editing this file you can use the 
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in 
    machine.config.comments usually located in 
    \Windows\Microsoft.Net\Framework\v2.x\Config 
-->
<configuration>
  <connectionStrings>
    <add name="constring"  connectionString="Data Source=*********;Initial Catalog=decent_Schl;User Id =*********;password=*********"  providerName="System.Data.SqlClient" />
  </connectionStrings>

  <system.web>

    <!-- 
            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.
        -->
    <compilation debug="false" targetFramework="4.0">
    </compilation>
    <!--
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
    <authentication mode="Windows"/>
    <!--
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
  </system.web>
</configuration>
Posted
Updated 16-Jan-20 20:50pm
Comments
MadMyche 16-Jan-20 21:15pm    
Unless you are throwing an SQL Exception; I highly doube that the connection string is the issue, unless that SQL is on your machine- in which case yu'd probalby see a timeout
Dave Kreskowiak 17-Jan-20 0:12am    
Do you know that the first time you navigate to an ASP.NET page that has been either newly uploaded or idle for a period of time you are kicking off a compile and load of the assemblies involved in the page you requested?

Subsequent requests for the same page will then load much faster.
F-ES Sitecore 17-Jan-20 4:55am    
Chances are it is just a slow database\server\network.
NP64 17-Jan-20 14:46pm    
It also depends on what your loading on a page. Try with only one record/value and check. If you are using any JS/Jquery check using developer tool where it takes more time.
ZurdoDev 17-Jan-20 16:59pm    
What all of them said. ^

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900