Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Problems
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 14th, 2011, 02:04 PM
tbcaffil30 tbcaffil30 is offline
 
Join Date: Aug 2011
Posts: 14
Question Slow database queries

Hello,

I am currently using hostmonster as my service provider. My site was suspended last week. I removed one wp plugin and repair and optimized my databases. My site was turned back on but is still showing high query times for certain table in the database. The wp_dfr_shop_products table is consistently having a query time of over 2 seconds. Sometimes way more. Hostmonster is telling me this is too much. Is this simply because of the amount of products I have in the store. Currently around 50k. Any ideas how I can reduce the query times?

Thank you.

Tim.
  #2  
Old November 14th, 2011, 02:07 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi

It could be a combination of having 50,000 products in a table plus being on a shared server.

First, I would install a caching plugin to prevent so many queries being made on your site.

In version 3.4 (which should be released this month) we are focusing on optimizing DB queries along with other types of optimizations. I think this will make a difference.

Eric
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
slow store squeezywheezy Problems 1 October 20th, 2011 06:04 PM


All times are GMT -5. The time now is 06:48 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.