BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Large cart (many items) causing slow page loads
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
I'm pretty sure it has something to do with the number of SQL calls required to evaluate volume pricing, discounts and customer specific pricing for each line item which doesn't happen when editing an order unless you request a recalculation.
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
Just to help out we have the same issue on products without volume prices, customer specific prices or discounts.
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
We have figured out the issue with this and we have a fix. Is there anyone that would be willing to let us test the release on their store? It would have to be an unmodified store so that we can just drop new dll's into their bin folder. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 7/26/2004(UTC) Posts: 155 ![United States]( "United States")
|
Justin,
We can do it on one customer store we've had issues with... |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Alright, I will send you an e-mail with the files attached. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 7/26/2004(UTC) Posts: 155 ![United States]( "United States")
|
|
|
|
|
|
|
|
Rank: Member
Joined: 7/26/2004(UTC) Posts: 155 ![United States]( "United States")
|
Seems to be better, but still having latencies.
With fewer than 10 products, cart page times are between 5-10 seconds; going back to item pages are approx 5-10 seconds each.
Above 10 items, cart page times start at 20-30 seconds, and progress worse as each item is added. I was up to 13 items and up to 45 seconds for cart page and 20-30 seconds for a keep shopping page. Checkout page at this point was 45 seconds plus still at the 13 items mark. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Would it be possible to get the address of the site that you installed the patch on? |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 7/26/2004(UTC) Posts: 155 ![United States]( "United States")
|
|
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Justin,
Please email me the files as well.
Thanks,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
what's the status on this issue? It's been a week since it looks like a preliminary fix has been out to a couple of "testers" -- I'm still seeing an awful lot of "timeout" errors and customers leaving with large carts |
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
This issue and the line item id not getting passed from the cart both need fixes. We're losing sales from the line item id issue, I'm sure many others are as well.
|
|
|
|
|
|
Rank: Member
Joined: 12/11/2006(UTC)
Posts: 3
|
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
No news on any issues which is real discouraging, not a good way to start 2008.
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
We have a fix for this issue that is in testing and we hope to have it ready to deploy this week.
|
|
|
|
|
|
Rank: Member
Joined: 12/11/2006(UTC)
Posts: 3
|
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Version 5.3.2 contains a fix for this issue.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.