Professional Web Applications Themes

Presence of Unneeded Fields? - ASP Database

No, your bandwidth will only be affected by what you actually ask for. Now, if you have a where clause and you have indexes (e.g. a clustered index) on the useless columns but not on the ones you're actually querying, you might see an efficiency hit (e.g. table scan). So, you'll want to check that any indexes on the table are geared to your application, and aren't wasted on useless columns. -- Aaron Bertrand SQL Server MVP [url]http://www.aspfaq.com/[/url] "MDW" <anonymousdiscussions.microsoft.com> wrote in message news:14E6E31C-39CD-4DB5-AB89-84B69ED63D0Fmicrosoft.com... > Hey all. > > Suppose I have a data table (SQL Server 2000) I'm going ...

  1. #1

    Default Re: Presence of Unneeded Fields?

    No, your bandwidth will only be affected by what you actually ask for. Now,
    if you have a where clause and you have indexes (e.g. a clustered index) on
    the useless columns but not on the ones you're actually querying, you might
    see an efficiency hit (e.g. table scan). So, you'll want to check that any
    indexes on the table are geared to your application, and aren't wasted on
    useless columns.

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]


    "MDW" <anonymousdiscussions.microsoft.com> wrote in message
    news:14E6E31C-39CD-4DB5-AB89-84B69ED63D0Fmicrosoft.com...
    > Hey all.
    >
    > Suppose I have a data table (SQL Server 2000) I'm going to be interacting
    > with via ASP. The columns I need are AcNum and OpenDate. The table also
    > happens to conatin, say, 20 other fields I have no interest in.
    >
    > Assuming my sql statements explicitly request only those fields I need
    > ("SELECT AcNum,OpenDate FROM...."), would those extra fields cause any
    > overhead to ASP? (We're in a very bandwidth-limited environment.) The
    > reason I ask is because the person who creates this data (not me) can
    > eliminate some of the fields that are generated if I request it. But if
    > there's no efficiency impact, I see no reason to.

    Aaron Bertrand [MVP] Guest

  2. #2

    Default Re: Presence of Unneeded Fields?

    OK, thanks

    I have a sneaking suspicion that some of the "unneeded" columns will become "needed" in the future, so I was hoping that the answer was that I could keep those columns intact.
    MDW Guest

Similar Threads

  1. AV Presence Resize
    By claudiu in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: November 18th, 11:00 AM
  2. AV Presence
    By Sjonniebravo in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: February 21st, 08:11 AM
  3. Clustering in the presence of hierarchies (fwd)
    By Ioannis Theoharis in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 11th, 03:27 PM
  4. Flash Presence
    By Carl Meyer in forum Macromedia Flash
    Replies: 0
    Last Post: October 20th, 11:38 AM
  5. unneeded e2fsck ?
    By Ulrich Lauther in forum Linux Setup, Configuration & Administration
    Replies: 3
    Last Post: August 8th, 03:35 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