Help with parse times?

[DrByte]

How's the performance now?

[RMsimp]

I am having a similar problem with parse times. I was using GoDaddy and getting parse times of 58-60 sec. They could not or would not help me I moved to hostgator and they are great. I still have long parse times 18-20 sec. I have upgraded to V1.5 and took all graphics off site and am putting back optimized graphics. Can anyone suggest where the bottleneck might be now. the site is conniesbookshelf.com

[DrByte]

I am having a similar problem with parse times. I was using GoDaddy and getting parse times of 58-60 sec. They could not or would not help me I moved to hostgator and they are great. I still have long parse times 18-20 sec. I have upgraded to V1.5 and took all graphics off site and am putting back optimized graphics. Can anyone suggest where the bottleneck might be now. the site is conniesbookshelf.com

Can you confirm what addons you're using on your site?

[RMsimp]

I am using checkout by amazon, paypal, the bookshelf template, and using product type book, and thats it. I am wondering if when they were adding products they could have put something in database wrong. This seemed to come on all at once but they don't know exactly when.

[DrByte]

I suspect that the indexes on the tables added by your "book" addon are at fault.

Perhaps try running the following SQL statements via phpMyAdmin:

alter table book_authors add index ba_name (book_authors_id,language_ida,book_authors_name,book_authors_nickname);
alter table book_authors_info add index bai_id (book_authors_id,language_id);
alter table books_to_authors add index bta_map (book_authors_id,language_idta,products_id);

Suggestion courtesy of senior tech staff at GoDaddy who offered this feedback when I asked them if there was any reason why their server would be so slow.

[RMsimp]

Thank you very much, that seems to have fixed the problem. I wish the 5 weeks I was calling GoDaddy for help they would have given me that info. I wouldn't have moved the site. Again thank you

[DrByte]

Thank you very much, that seems to have fixed the problem.

Cool. Glad it helped!

I wish the 5 weeks I was calling GoDaddy for help they would have given me that info. I wouldn't have moved the site.

Valid point. This same person has told me that they're actively working on ways to help address that in the future. They've had some big top-level mgmt changes that are re-shaping how they do things, and it's looking more promising. Hopefully this means their image can change moving forward.