Results 1 to 7 of 7

Thread: Database Optimization

  1. February 15th, 2012 #1
    mattpont
    mattpont is offline
    Thread Starter
    Rookie mattpont's Avatar
    Join Date
    Oct 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database Optimization

    Is it just me or are there some really heavy database joins going on with Clipper?

    My site is on a VPS with 4GB ram and 2CPUs and should absolutely fly, but it doesn't.

    I have W3 Total Cache installed, so when a page is cached it is fine, for example:

    Time to First Byte on the homepage is 11 seconds (!), but when it is cached it is 0.094 seconds. I'm pretty sure the issue is the database queries that the theme makes to the db to return the coupons.

    Does anyone else have these issues and any hints? I have the latest theme installed.
    Reply With Quote Reply With Quote
  2. February 15th, 2012 #2
    mattpont
    mattpont is offline
    Thread Starter
    Rookie mattpont's Avatar
    Join Date
    Oct 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  3. February 25th, 2012 #3
    meloniq
    meloniq is offline
    meloniq's Avatar
    Join Date
    May 2011
    Location
    Poland
    Posts
    1,079
    Thanks
    17
    Thanked 178 Times in 159 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Have Clipper website?! --> You need coupons importer!!!
    See available integrations with affiliate networks: Commission Factory, CJ Affiliate, Daisycon, Rakuten LinkShare, ShareASale, Tradedoubler, TradeTracker

    Payment gateways: Bitpay, Dotpay, PayU PL, Przelewy24, Skrill

    me @ AT || meloniq.net
    Reply With Quote Reply With Quote
  4. March 5th, 2012 #4
    mattpont
    mattpont is offline
    Thread Starter
    Rookie mattpont's Avatar
    Join Date
    Oct 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  5. March 5th, 2012 #5
    meloniq
    meloniq is offline
    meloniq's Avatar
    Join Date
    May 2011
    Location
    Poland
    Posts
    1,079
    Thanks
    17
    Thanked 178 Times in 159 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Have Clipper website?! --> You need coupons importer!!!
    See available integrations with affiliate networks: Commission Factory, CJ Affiliate, Daisycon, Rakuten LinkShare, ShareASale, Tradedoubler, TradeTracker

    Payment gateways: Bitpay, Dotpay, PayU PL, Przelewy24, Skrill

    me @ AT || meloniq.net
    Reply With Quote Reply With Quote
  6. March 5th, 2012 #6
    mattpont
    mattpont is offline
    Thread Starter
    Rookie mattpont's Avatar
    Join Date
    Oct 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Reply With Quote Reply With Quote
  7. March 5th, 2012 #7
    meloniq
    meloniq is offline
    meloniq's Avatar
    Join Date
    May 2011
    Location
    Poland
    Posts
    1,079
    Thanks
    17
    Thanked 178 Times in 159 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Have Clipper website?! --> You need coupons importer!!!
    See available integrations with affiliate networks: Commission Factory, CJ Affiliate, Daisycon, Rakuten LinkShare, ShareASale, Tradedoubler, TradeTracker

    Payment gateways: Bitpay, Dotpay, PayU PL, Przelewy24, Skrill

    me @ AT || meloniq.net
    Reply With Quote Reply With Quote
« No Coupon Code after Update to 1.2.4 | Pages in the top menu why are they not showing? »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search Engine Optimization
    By jonpharr in forum ClassiPress General Discussion
    Replies: 6
    Last Post: July 28th, 2011, 02:31 AM
  2. [SOLVED] Is this a known database bug?
    By doctorcilantro in forum Report ClassiPress Bugs
    Replies: 11
    Last Post: April 10th, 2011, 08:27 PM
  3. [SOLVED] SEO or SITEMAP optimization
    By piplo in forum Report ClassiPress Bugs
    Replies: 4
    Last Post: March 4th, 2011, 05:51 AM