Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    2

    Question Unanswered: sql query performace

    HI ,
    Can any one let me know how to fine tune my application to handle 60000 records with 12 columns to execute from a component and convert this data into XML and display in a html format . Query is timing out generally.
    I really don't know this is a right forum to post the message or not.
    Thanks in advance

  2. #2
    Join Date
    Nov 2001
    Posts
    36
    12 columns and 60k records should be fine with the sql server.
    Can you use IIs server to get the data from the sql server in XML format.

    http://msdn.microsoft.com/library/de..._xml1_59m4.asp

    Try out this may be you will get what you are planning to get.
    Hope this helps.

    Thanks

Posting Permissions

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