SQL Server and Stored Procedures

Results 1 to 2 of 2

Thread: SQL Server and Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default SQL Server and Stored Procedures

    I working on writing a HelpDesk software for work and am using ASP with a SQL Server 6.5 backend. The details page has a number of dropdown boxes that are being populated from different tables. My problem is that the page loads real slow. I was wondering if someone could tell me what to do to make the page load faster.<BR><BR>If I used stored procedures for each of the dropdown menus would it speed things up? <BR><BR>Any help would be greatly appreciated.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server and Stored Procedures

    there are lots of ways you can speed things up - SPs are one. getRows() or getString() is another. keeping your connections to a bare minimum is also good practice. turning off session state if not required has some effect. JScript runs quicker than VBScript, too. cut down on the number of delimiters used<BR><BR><BR>basically TONS of ways<BR><BR>j<BR>http://www.infinitemonkeys.ws/<BR>

Posting Permissions

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