Help !!

Results 1 to 3 of 3

Thread: Help !!

  1. #1
    Join Date
    Dec 1969
    Posts
    866

    Default Help !!

    My sql queries are complex and they take around 2 min....and they return small number of rows...around 120....The interesting fact is that it takes equal amount of time to display that data back to the browser. I do not understand as to why it takes so long to display back. ( and also it takes almost same amount of time as sql does.) Any insight is appreciated.

  2. #2
    Jairo Guest

    Default RE: Help !!

    Sam,<BR>Without seeing your query, table structures, and number of records - it&#039s difficult to say what is causing your query delay. You can try taking a look at the indexes and make sure there getting used properly.<BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com

  3. #3
    Join Date
    Dec 1969
    Posts
    866

    Default RE: Help !!

    Thanks for the reply. I am happy with my sql response. I am puzzeled as to why after I get the data from SQL server, ASP is taking equal amount of time to display the results back to the browser.

Posting Permissions

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