increase speed

Results 1 to 6 of 6

Thread: increase speed

  1. #1
    Linh Guest

    Default increase speed

    Is there anyway to increast the loading time on the sql server?<BR>My asp pages are fast under the local odbc dsn link but when I put it on the server, it&#039;s almost twice slower. Any suggestion is greatly appreciated! thanks!<BR>

  2. #2
    <eop> Guest

    Default Using stored procs?


  3. #3
    Reggie Guest

    Default RE: increase speed

    Open up the IIS Settings and check the "Make SQL Go Faster" checkbox. Ok, I&#039;m not funny. There&#039;s no quick way of increasing the speed other than going through your code and streamlining it. Get rid of all those SELECT *&#039;s unless you really need everything. Make sure there are no better ways to do old algorithms. I used to not even know what autonumber fields were so I mimicked them by SELECTing the MAX() and adding 1 to it.

  4. #4
    Linh Guest

    Default RE: increase speed

    Yeah I did change my select statement to select only the required fields but still doesn&#039;t help much.. I have some if statements in there wonder if that causes it to slow down..Thanks for your help!<BR>

  5. #5
    Linh Guest

    Default RE: Using stored procs?

    Could you explain a little or point me a reference to using stored procs?? Thanks!

  6. #6
    Join Date
    Dec 1969

    Default Post a sample page...

    ... and we&#039;ll evaluate potential improvements. It may be an issue with your ADO methodologies. Are you using WinNT or Win2k?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts