Professional Web Applications Themes

Performance of Data retrieval - Microsoft SQL / MS SQL Server

How to improve the performance pf 50 Lakhs data in SQL Server Database from my Application. What are the all measures to improve the performance of the data retriveal from SQL Server....

  1. #1

    Default Performance of Data retrieval

    How to improve the performance pf 50 Lakhs data in SQL
    Server Database from my Application.

    What are the all measures to improve the performance of
    the data retriveal from SQL Server.

    Udayakumar.S Guest

  2. #2

    Default Re: Performance of Data retrieval

    For a beginning, do please check the articles at
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tunovw_9mxz.asp[/url],
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_536v.asp[/url],
    [url]http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp[/url].

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: [url]http://www.sqlserverfaq.com[/url]
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - [url]http://www.sqlpass.org[/url]

    "Udayakumar.S" <udaysoftsolveit.com> wrote in message
    news:1e5701c33ec9$b2700420$a601280aphx.gbl...
    > How to improve the performance pf 50 Lakhs data in SQL
    > Server Database from my Application.
    >
    > What are the all measures to improve the performance of
    > the data retriveal from SQL Server.
    >

    Dejan Sarka Guest

  3. #3

    Default Re: Performance of Data retrieval

    Udayakumar,

    If you want to improve the speed of queries that retrieve
    just one or very few rows at once using a WHERE clause, like

    select someColumn
    from someTableWith50LakhsRows
    where someColumn = 3948 -- or any condition

    the key to good performance is to use suitable indexes on the
    large table. For SQL Server, 50 Lakhs (5,000,000) rows is
    not difficult to handle, but without any index, all rows will have
    to be inspected for a query like the one above, and with an
    index, only a very few rows' worth of data will have to
    be inspected.

    Most books on SQL Server discuss indexing strategies somewhat,
    and the Index Tuning Wizard can also help you choose helpful
    indexes for your queries.

    Steve Kass
    Drew University

    Udayakumar.S wrote:
    >How to improve the performance pf 50 Lakhs data in SQL
    >Server Database from my Application.
    >
    >What are the all measures to improve the performance of
    >the data retriveal from SQL Server.
    >
    >
    >
    Steve Kass Guest

Similar Threads

  1. Data retrieval from MS SQLwith ASP.NET 2.0
    By Mzekeke in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: July 8th, 01:55 PM
  2. XML and Flash Data Retrieval
    By stacyp in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: April 18th, 08:02 PM
  3. Poor Performance when using data
    By neilmiddleton in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: September 5th, 04:13 PM
  4. Input on Searching and Data Retrieval for a PDF Collection
    By Wilbur_Shen@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: May 20th, 09:03 AM
  5. Where to store the data for best performance?
    By Emilio Azeri webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 1
    Last Post: January 2nd, 01:15 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139