Results 1 to 4 of 4

Thread: lots of queries ? is this bad ?

  1. #1
    Senior Member
    Join Date
    Jul 2003
    Posts
    774

    lots of queries ? is this bad ?

    i looked at photopost which is what im using and did a print function and it says

    MySQL queries: 470
    is that bad ? it goes up to as much as 505

    isnt vb and ipb only like 15 queries ?

    does this put alot of strain on a server ?

  2. #2
    Chronic Entrepreneur
    Join Date
    Nov 2003
    Location
    Tulsa, Oklahoma, USA
    Posts
    1,112
    I'm not sure how many queries would be too many for you. It depends on over how long of a time period that number of queries were made. It also depends on what kind of server your using and if it's shared with other users and sites.

    A good way to see if this is straining your server would be to install phpsysinfo. Look at the server load as photopost is being used.

  3. #3
    Registered
    Join Date
    Nov 2003
    Posts
    67
    If you're worried about server overload, you could cache the content the query returns and refresh it every 6 hours or so. I use PHPCache_Lite. It's a small php class that does it for you.

  4. #4
    Senior Member
    Join Date
    Jul 2003
    Posts
    774
    well i talked to the developers and they fixed it i had to many categories which caused alot of queries its down to around 14 now

Similar Threads

  1. Multiple SQL queries
    By chromate in forum Website Programming & Databases
    Replies: 21
    Last Post: 02-05-2004, 11:58 AM

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
  •