SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast guitarnoise's Avatar
    Join Date
    Nov 2002
    Location
    Southeast Asia
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    using generateindex.php from Kevin's book

    I've been using the generateindex.php script from chapter 10 of Kevin's book. I use the script to calculate the ten most popular articles by grabbing the hit count from a MySQL table. I tested in my local machine and it worked fine. Then I tried using it on my server and tried to get the 100 most popular articles. It gets the top ten all right, but never makes a semi-dynamic page lisitng 100 articles. It stops making the list in the mid-30s somewhere. I don't see any error messages. Why is this? Is it taking too long to process the php and timing out?

  2. #2
    Put your best practices away. The New Guy's Avatar
    Join Date
    Sep 2002
    Location
    Canada
    Posts
    2,087
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    I know this may sound silly but are their actually 100 articles to be ranked?
    "A nerd who gets contacts
    and a trendy hair cut is still a nerd"

    - Stephen Colbert on Apple Users

  3. #3
    SitePoint Enthusiast guitarnoise's Avatar
    Join Date
    Nov 2002
    Location
    Southeast Asia
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh yeah. it's a large database with 500 articles. even if i try to get the top 50 it always gets cuts off.

  4. #4
    ********* Genius Mike's Avatar
    Join Date
    Apr 2001
    Location
    Canada
    Posts
    5,458
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by guitarnoise
    Is it taking too long to process the php and timing out?

    Most likely. Either change your time out, or make a temp table that tracks what articles need to be run through the script and then do it in cycle of 20.
    Mike
    It's not who I am underneath, but what I do that defines me.

  5. #5
    SitePoint Enthusiast guitarnoise's Avatar
    Join Date
    Nov 2002
    Location
    Southeast Asia
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Mike
    Most likely. Either change your time out, or make a temp table that tracks what articles need to be run through the script and then do it in cycle of 20.
    Do you mean make a temporary MySQL table on the fly using PHP?


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
  •