SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict proph3t's Avatar
    Join Date
    Jun 2004
    Location
    Arizona
    Posts
    246
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unoptimized DB, Need Advice

    I'm having trouble with a script that is running very slowly pulling info from a MySQL database. I explained here and was recommended posting here.

    Heres a screenshot of one phpmyadmin page from the table I'm querying:


    ..there are 206 pages of that.

    Is there some way to optimize this, or is it even a problem with the database being too large?

    If so, the load is only about 8 seconds when I use the script, maybe I should just use a simple cache system and upate it only once a week or so.

    Any help is appreciated

  2. #2
    Chessplayer kleineme's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    please show us the queries which are running slowly and tell us which indexes you have for that table.
    Never ascribe to malice,
    that which can be explained by incompetence.
    Your code should not look unmaintainable, just be that way.

  3. #3
    SitePoint Addict proph3t's Avatar
    Join Date
    Jun 2004
    Location
    Arizona
    Posts
    246
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I implemented a simple cache system and everything is running smoothly now. Thanks!


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
  •