SQL Server Performance

sql-server-performance.com Search page

Discussion in 'Please Tell Us What You Think' started by pavankan, Feb 5, 2004.

  1. pavankan New Member

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />I have been frequenting this site these days and I think it is great.<br /><br />Today, I have a question about the site itself..<br /><br /><br />The 'Search' page actually has a list of all the users!! A whopping 2275 usernames listed in a dropdown box. (Yeah, I counted them!)<br /><br />I was wondering if some one could comment on the rationale of such a list..<br /><br />I mean what went into the decision behind offering it on the website.<br /><br />And most importantly, how is it implemented? A drop downlist with so many rows is a very common nightmare for most developers. Can the experts share some of the bright ideas that have gone into it?<br /><br /><br /><br /><br />
  2. pavankan New Member

    [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />I 've actually tested it using an account I registered: aaaDropDpwnListTester...<br />It appeared in the drop down instantly!![^]<br />FANTASTIC!<br /><br />Moderator, you may want to delete that account: I made it only as a test.<br /><br /><br />The general problem with Micrososft products is, one can very easily put together hi-tech stuff.; A real neat distributed information system. However, most times the defalut settings or such thinhgs do not produce optimal performance. You gotta delve in, and understand the stuff.. That's when you get such highly capable systems: Whatever went behind that drop-down list: GOOD JOB!<br /><br />Now, if some one could please let me in on how..[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Sunny Kanaparthy is a software developer with the University of New Orleans, LA, USA.<br /><br />
  3. Chappy New Member

    Not sure I see whats so amazing about it <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br />Its just a dynamically generated page with a simple select behind it<br /><br /><pre><br /> &lt;option value="0"&gt;All Members&lt;/option&gt;<br /> &lt;option value="1995"&gt;5409045121009&lt;/option&gt;<br /> &lt;option value="216"&gt;5phantom5&lt;/option&gt;<br /> &lt;option value="1342"&gt;66cooper&lt;/option&gt;<br /></pre><br /><br />I think as interfaces go, its a poor design to add a drop down list, but I think this forum is an off-the-shelf one and so the guy who made that decision is not likely to be reading here
  4. FrankKalis Moderator

  5. FrankKalis Moderator

  6. vbkenya New Member

    Chappy may be revealing more than what meets the eye. "5409045121009" is probably one of secret codes somewhere (password,fragment of his credit card, security code for his house). Hackers galore!

    That drop-down list is a 'poor' design choice given the fact few users really want to track/find posts by a specific author. I suppose it was implemented with less than a hundred users in mind. Fortunately, Brad had nothing to do with it - ask the Snitz http://forum.snitz.com/] guy about it. Or don't bother, it is free, it works and you now know how it is done.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  7. FrankKalis Moderator

    No, I don't think so. I was just asking, because a fellow member on SQL Server Central uses this as username (Obviously here too) [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br />I thought it might have a deeper meaning.<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
  8. Luis Martin Moderator

    Well, just wait for Brad.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  9. Chappy New Member

    This is not going to be much use to a hacker <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br />5409045121009 is simply a standard user.<br />Check him out if you wish<br /><br /<a target="_blank" href=http://www.sql-server-performance.com/forum/pop_profile.asp?mode=display&id=1995>http://www.sql-server-performance.com/forum/pop_profile.asp?mode=display&id=1995</a>
  10. bradmcgehee New Member

    The reason for this list is to allow people to search for specific posts by specific members of the forum. This is a feature of the Snitz forum. All the accounts you see listed are actual users, even the strange ones. This same information is available from the members page, just in a different form.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  11. pavankan New Member

    For the drop down list to have a dynamic list of over 2000 names in it:<br />1. Transport to client browser should be real slow<br />2. Retrival from database on each request is resource intesive<br /><br />My question was, how does the system get around that?<br /><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Chappy</i><br /><br />Not sure I see whats so amazing about it <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br />Its just a dynamically generated page with a simple select behind it<br /><br /><pre><br /> &lt;option value="0"&gt;All Members&lt;/option&gt;<br /> &lt;option value="1995"&gt;5409045121009&lt;/option&gt;<br /> &lt;option value="216"&gt;5phantom5&lt;/option&gt;<br /> &lt;option value="1342"&gt;66cooper&lt;/option&gt;<br /></pre><br /><br />I think as interfaces go, its a poor design to add a drop down list, but I think this forum is an off-the-shelf one and so the guy who made that decision is not likely to be reading here<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
  12. Chappy New Member

    Shouldnt be too slow (well, clearly it isnt, im on a 56k at home and it loads without much delay!)<br /><br />lets say average username is 15 chars (and thats probably worst case). + 8 chars for '&lt;OPTION&gt;' + 9 chars for '&lt;/OPTION&gt;'<br />So 32 bytes per user: 32 * 2000 = 64K.. the size of a medium-large banner advert! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />
  13. bradmcgehee New Member

    Also, this column is properly indexed, so the data is returned quickly.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page