Blog 4 Jordan Day

Visitor of the day


  • You
    from

Brag Stats

  • Comments:25,004
  • Articles:2,000
  • Article Hits:12,459,805
  • Unique Visitors:2,000,438
  • Rss Subscribers:3,052
  • Comment Subscribers:2,530
  • Spammers:136,315
  • Generated :757,671 spams
  • Monitoring:3,942,477 spam IPs
Powered by Qwaider Shield

Recent Comments

Check out the latest pictures on Sweetestmemories

« You have been shamefully dischargedHow to stream audio in your car »

Fun with databse

  • By: Qwaider

  • On:Wednesday, September 06, 2006 8:47:04 AM
  • In:Thoughts
  • Viewed: (5529) times

    • Currently 4.5/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5

    Rated 4.5/5 stars (173 votes cast) Thanks for your vote!

    I was playing around and found some interesting statistics ... I thought I share :)

    299 Unique commenter Names

    862 Unique IP addresses

    296 Unique Email addresses

    216 Unique web sites

    228 Unique Article ID's

    2955 Comments

    3.555MB total size of comments

    Wow! This is awesome

    Other Memories Documented on September 06
    « You have been shamefully dischargedHow to stream audio in your car »

    Memories....

    • #1
    • 7ala
    • Windows Internet Explorer
    • Said
    • On: 9/6/2006 9:18:47 AM
    great ... mashallah 3alek :)
    • #2
    • 7usam
    • Windows Internet Explorer
    • Said
    • On: 9/6/2006 11:49:04 AM
    اللهم زيد و بارك
    باقي عداد الزوار
    ;)
    how many unique level of indexing(0, 1 or 2)?
    Well, it depends on the table. Each one has different properties :) I have a few of those, one for articles, one for comments, others for configuration, and my anti-spam system
    I got these statistics manually, I was just goofing around :)
    Dude,
    You know what! You should make a tiny company with me. I put Google Adsense in ur site. You take half the money and I take the other half.

    I do not know why I should take half the money.

    Believe me, you might make good money from AdSense. And I provide PPC SEO tips (Another reason why I take half the money)

    P.S: Excuse me future abu shreek, I am not sure if your answer about indexing has anything to do with my question :). see http://en.wikipedia.org/wiki/Index_%28database%29
    2D indexing implemented for DBs with 100Milions+ of rows, it is not possible to join them. Msn, google, yahoo does it for log in tables. I think u have 0 D indexing.

    Hala 3mmy
    Well your DB need maintenance. I wrote a comment and it is not getting rendered here!!!

    Ok baby, let us get you on PPC adsense board. I take 50% of benefits :) and u take the remaining. I provide PPC SEO tips and you provide me by people who click a lot :)

    Google Adsense is cool. Remember, 50% for me. If you really have good traffic, we will make good revenue. For now, change for us the hot robots file (http://blog.sweetestmemories.com/robots.txt) we wana sexy one to get us on top 10 of any SERP.

    P.S: I think u have 0 level indexing :) ! see wikipedia for indexing. 1D enough when have millions of rows. MSN have 2D indexing, they can not get tabled joined with 1D indexing.

    Hala 3mmy
    Hehehee... Ok first I'm not going to bother my readers with unwanted ads :) if I wanted to do that I would've done it long time ago :)
    So I'll give you 50% of that,better yet, you can get all 100% LOL
    Now regarding indexing. I have to admit, I didn't get it the first time, after reading that article I don't think I have in that way. I should probably invest some time into it, but since I'm not a DB guru(my experience and knowledge is rather basic) and I'm still playing around with it (my forte is networking)
    Now, I have one table with >600k rows which might benefit from that, but since it's full of IP addresses, I'm not sure how effective that would be (bang-for-the-buck would probably be low)

    As for your comment, It just needed authorization, since you had a link in there :)
    I think you are giving me 100% but without 1 :(.

    Baby, if u have 600k rows, it is the time to index. I am not sure if u join tables. If you do, I am sure that ur site will NOT retrieve anything from any table at any day. Once rows reach 1 million in a couple of tables and u do join. The virtual table gonna be 1million * 1million ! ur stored procedures will time out.

    0% !!!!!!!!!!!
    Why would I join with IP addresses? I just need to know if it's there or not :)
    Second, the only tables that are joined are Comments, and Articles, everything else is pretty much independent
    I don't even use stored procedures :), remember the number of articles is going to get to what, 1000? 10,000? 100,000? That's a lot of articles of which I retrieve 15 excerpts for the main page, and 1 at at time for article reading.
    This is not MSN or Google, this is a tiny little blog man :)
    The main database structure is normalised to third normal form with indexes on all primary key values and indexes on all pertinant fields that will be used in any joins. I can't comment on the changes or additions that Qwaider has made to his database but the underlying structure is well-built and very robust.

    With regards to adsense, whilst I do use in on my site I'm thinking of getting rid of it again. It looks fugly no matter what you do to it and unless you drive serious aounts of traffic or dabble in click fraud then the returns don't really justify beating your site with the ugly stick! I think I've been averaging ~$12 every couple of weeks through adsense which, lets face it, is bugger all.

    Good luck with running it on your site, but I'd remove your post asking people to click on the ads, it's against Googles T&C's and will see you being black listed.
    Oh yeah, hi Qwaider. Still busy as ever I see :D
    Hey Patrick, Lovely seeing you here, thank you very much for visiting, and sharing some insight since I'm seriously not a DB person.
    The 600K row table I was talking about is my antispam system, it's working great so far, and I can't notice any over head (retrieved only when commenting)

    Really a pleasure to see you here Patrick
    Yes yes Patrick, I hope the interest continues. Man.... it's SOOOOOOOOO honoring to see you here. I'm so excited

    I would love to share all the updated code with you :)
    You too can have your Memories Documented

    Country:

    HTML has been disabled but if you wish to add any hyprlinks or text formating you can use any of the following codes: [B]bold text[/B], [I]italic text[/I], [U]underlined text[/U], [S]strike through text[/S], [URL]http://www.yourlink.com[/URL], [URL=http//www.yourlink.com]your text[/URL]

    Whisper (your comment will not be displayed)

    Please refer to Commenting policy


    Notify me of follow-up comments by email
    « You have been shamefully dischargedHow to stream audio in your car »
    Read by:
  • Guests(3)-
  • |
  • Guest-
  • |
  • Guest-
  • |
  • Guest-
  • |
  • Guests(8)-
  • |
  • Guests(2)-
  • |
  • Guests(53)-
  • |
  • Guests(402)-
  • |
  • Guest-
  • |
  • Guests(369)-
  • |
  • Guests(3)-
  • |
  • Guest-
  • |
  • Guests(2)-
  • |
  • Guest-
  • |
  • Guest-
  • |
  • Guests(12)-
  • |
  • Guests(265)-
  • |
  • Guests(54)-
  • |
  • Guests(14)-
  • |
  • Guest-
  • |
  • Guests(11)-
  • |
  • Guest-
  • |
  • Guests(13)-
  • |
  • Guests(4)-
  • |
  • Guests(14)-
  • |
  • Guests(5)-
  • |
  • Guests(20)-
  • |
  • Guest-
  • |
  • Guests(116)-
  • |
  • Guests(12)-
  • |
  • Guest-
  • |
  • Guests(8)-
  • |
  • Guest-
  • |
  • Guests(91)-
  • |
  • Guests(11)-
  • |
  • Guests(36)-
  • |
  • Guests(3)-
  • |
  • Guests(2)-
  • |
  • Guests(2)-
  • |
  • Guests(8)-
  • |
  • Guests(9)-
  • |
  • Guests(98)-
  • |
  • Guests(3655)-
  • |
  • Maioush-
  • |
  • Summer-
  • |
  • Guests(2)-