Results 1 to 4 of 4
  1. #1

    Page Loads slow. Can't find why.

    Hi I have page that uses sql and I am not sure why it loads slow.

    How can I find out why it takes a long time to load. What type of tools are availabe for finding the reason that it load slow. All the pages on the site load fast but one loads slow.

    Can some please let me know what I can do.

    here is a link to page that loads slow

    http://www.mymags.com/moreinfo.php?itemID=1370

    Thank You

  2. #2
    Join Date
    Jul 2002
    Location
    Atlanta, Georgia
    Posts
    339
    loads plenty fast for me... took about two seconds...


    is the script sql intensive? ie, doing more than just grabbing the info? is there anything else resource hogging on the server? is it a shared server? it probably is, and its probably just the load on mysql thas slowing the db reads...

  3. #3
    Join Date
    Jul 2002
    Location
    The Big Easy -New Orleans
    Posts
    341
    Took about 6 for me.. drew header portion and then sat. After several seconds it completed the page all at once.

    Since you are using SQL, you might consider looking at the select statement(s). I assume you have setup indexing on the appropriate fields.
    Lagniappe Internet L.L.C. - Wholesale Reseller and VPS Hosting.
    Lagniappe (lan-yap) - An extra or unexpected gift or benefit.
    HostEntrepreneur - Hosting news, reviews, tips, tricks, help and the occassional rant

  4. #4
    Thank You for resonse. I just starte to take off code to see what the problem with the site.

    It seems that
    SELECT title,product.prd_id FROM product
    LEFT JOIN prd_related ON product.prd_id=prd_related.prd_id_1
    WHERE prd_related.prd_id=$itemID order by priority

    statement cause problem.


    How do I test how fast it takes for this query exceute.

    Thank You

Posting Permissions

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