When making edits or adding new products, I get a huge lag time (anywhere between 20 - 30 seconds) each time I click on the Edit tab. This was working fine 2 days ago. I should mentione this also happened once before and after about a month or so, and it somehow resolved but not sure how. Does anyone have an idea of what could be causing this and how I might be able to fix it?
Wed, 01/16/2008 - 19:29
Re: Huge lag time when making edits/adding new product
Hmm... in a case like this, I usually suspect server issues. That's not to say it can't be a Drupal issue w/ some module lagging things down, but if you haven't added/removed any modules in a while I'd suspect the server. Are you perhaps using shared hosting?
Re: Re: Huge lag time when making edits/adding new product
I am on a semi-private server. Only a few others on this one.
Re: Re: Re: Huge lag time when making edits/adding new product
Might be a database issue, especially if your database isn't on the same server as your Drupal/Ubercart installation. (A lot of web hosts use a shared database server, so even if you're on a "semi-private" you may be greatly affected by other database users and bandwidth.) You can use phpMyAdmin to look at performance, you can install the devel module (http://drupal.org/project/devel) and see what it says about your query times. Try this utility to analyze and fix performance issues: http://highervisibilitywebsites.com/tuning-primer.sh.zip
Re: Re: Re: Re: Huge lag time when making edits/adding new produ
Thanks. I'll give it a try and let you know how it works.
Re: Re: Re: Re: Re: Huge lag time when making edits/adding new p
It's been a while since I first posted about this, but unfortunately I'm still experiencing huge lag times that only seem to lengthen.
The devel module has been installed and at last check the page generation time was 955.83 milliseconds - it's less than 1 second, however, in reality the times range anywhere from 20 - 30 seconds and sometimes longer.
My web designer and web host company have confirmed that I have sufficient bandwidth, in fact, my account is their second largest bandwidth user, with the remaining accounts far behind. None of the other clients have had any issues with site speed.
At one point, I even thought maybe it might be my computer so I tested from another computer that is fairly new and in great condition and I still experienced the same problems. I've tested in both IE7 and Firefox. This lag time makes it extrememly difficutl to do some edits because it is so time consuming. I'm just at such a huge loss as to what could be causing the problem.
Can anyone shed some light on what they think may be causing this and a possible solution? Any help you can offer is very much appreciated!!!!
Re: Re: Re: Re: Re: Re: Huge lag time when making edits/adding n
Can you post a list with active modules?
How many entries are there in your term_node table?
Do you use revisions?
What did devel report as the slowest querys?
Do you have slow-query-log active on mysql? (What does it say?)
We have some experience with speeding up drupal, but figuring out the bottleneck needs to get done first 
Re: Re: Re: Re: Re: Re: Re: Huge lag time when making edits/addi
Thanks for responding. I'm really sorry but I'm not quite sure how to answer your questions because I don't understand much about my cart.
The installed and active modules are:
content
image
contact
help
menu
path
search
statistics
taxonomy
(devel)
(devel node access)
tables api
image
image gallery
image import
imagecache
mime mail
meta tags
pathauto
phpbb
secure pages
simplenews
simplenews template
thickbox
token
ubrowser
inventory api
simple stock levels
cart
order
product
store
attribute
catalog
notify
payment
shipping quotes
shipping
taxes
manufacturer
product kit
product reference
flat rate
UPS
store coupons
credit card
paypal
configurable content links
state machine api
workflow-ng
workflow-ng UI
Re: Re: Re: Re: Re: Re: Re: Re: Huge lag time when making edits/
Ok, I now have the rest of the answers to your questions. Whatever insight you can give me or suggestions you can offer to help speed things up is very much appreciated.
Q: How many entries are there in your term_node table?
Answer: 2,810 rows
Q: Do you use revisions?
Answer: there are 1,052 rows in the node_revision table, the same number as in the node table
Q: What did devel report as the slowest querys?
Answer: (I think this may be the report you are referring to?)
176.94 1 uc_zone_select SELECT * FROM uc_zones WHERE zone_country_id = 840 ORDER BY zone_name
166.79 1 uc_country_select SELECT * FROM uc_countries WHERE version > 0 ORDER BY country_name
86.81 1 filter_list_format SELECT * FROM filters WHERE format = 1 ORDER BY weight ASC
76.26 1 simplenews_user_is_subscribed SELECT * FROM simplenews_subscriptions s INNER JOIN simplenews_snid_tid t ON s.snid = t.snid WHERE s.mail = '******@************.com' AND s.uid = 4 AND t.tid = 1
72.27 2 uc_manufacturer_load SELECT m.*, t.* FROM uc_manufacturers m JOIN term_data t ON m.tid = t.tid WHERE m.tid = 100
70.81 1 filter_format_allowcache SELECT cache FROM filter_formats WHERE format = 1
44.74 1 user_load SELECT * FROM users u WHERE LOWER(mail) = LOWER('******@************.com')
31.72 1 taxonomy_term_count_nodes SELECT t.tid, COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.nid = n.nid WHERE n.status = 1 GROUP BY t.tid
28.92 1 _uc_attribute_alter_form SELECT * FROM uc_product_attributes WHERE nid = 1083 ORDER BY ordering
23.02 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '1045'