386000 Queries Checkout Confirmation Taking Forever (v1.3.7)

[compwhizmm]

Hi, I have a customer with 76 items in her cart and she has a simple coupon applied to her order. She goes to the checkout confirmation page, and it says this at the bottom:

Parse Time: 94.404 - Number of Queries: 386926 - Query Time: 81.477367542846

It is taking FOREVER to load. Does anyone know what the problem would be. The coupon is a very simple one. It simply gives a flat discount on her order without any restrictions.

If the coupon isn't applied, it loads fine:
Parse Time: 1.291 - Number of Queries: 4629 - Query Time: 0.99152225732422

Here's the configuration for the coupon:
Coupon Zone Restriction: 0
Coupon Name cwoods110108
Coupon Description
(Customer can see)
Coupon Amount 65.8200
Coupon Minimum Order 0.0000
Free Shipping No Free Shipping
Coupon Code cwoods110108
Uses per Coupon
Uses per Customer 1
Start Date 11/01/2008
End Date 11/05/2009


What can I do to fix this? It's driving me crazy. Not to mention the load rate on my server is through the roof.

Thanks!

[yellow1912]

Do these products have lots of attributes?

(And your zen version is?)

[compwhizmm]

Not a single product has an attribute. I'm running 1.3.7. I still think it has something do with the coupon. When the coupon isn't applied, I don't have this problem. The same thing happens with different coupons as well.

[yellow1912]

Say if you limit the number of products on the order to 10, does this happen?

Did you install any module? Which ones?

[compwhizmm]

Ok,

Here's the breakdown with 10 products on checkout confirmation

With Coupon:
Parse Time: 1.858 - Number of Queries: 5177 - Query Time: 1.559697796524

Without Coupon:
Parse Time: 0.296 - Number of Queries: 664 - Query Time: 0.13067283097839

I have a few mods, but none really on the checkout process. The only one I can think of that would affect checkout process files is Checkout w/o account.

THanks!

[Kim]

Checkout w/o account.

Just to satisfy our curiosity - can you replace the checkout with the stock one and test again?

[compwhizmm]

I ran it on a stock install. Here's the results

w/o coupon:
Parse Time: 0.632 - Number of Queries: 1318 - Query Time: 0.27100081842041

With coupon
Parse Time: 0.862 - Number of Queries: 1545 - Query Time: 0.38015111477661

I would try and remove those modules, but I can't mess with my site right now. I'm having a bunch of people ordering from a group and I don't want to disrupt anything. I'm thinking about just wiping my store and redoing it from the beginning. I've been having problems with orders showing blank as well. Maybe I've made too many changes to it. But, if anyone has an idea for quick fix of what might be causing it, I'd love to have some advice.

Thanks!

[Ajeh]

You said you are running v1.3.7 with the 664 to 5177 jump ...

Did you do your test site with v1.3.7 or with v1.3.8a?

[compwhizmm]

The test site was 1.3.8a.

[Ajeh]

Are you familiar with how to do a quick copy of your Live Site database to your Test Database and run the /zc_install and run the Upgrade on the database ...

Or, do a quick install of the exact version of Zen Cart for your test site that you are running now just to see the apples to apples comparisson ...

There is a minor change like you saw in v1.3.8a from no coupon to with coupon ...

I have not been able to reproduce the dramatic change like you are showing in v1.3.7 but I don't have handy a v1.3.7 at the moment in which to test this ...

And rather than torture me ... I thought it would be more fun to torture you on this test ...