Help with parse times?

[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.