Database Calls

[Dylan]

I have carried out a SQL profiler test on the Cart out of the box, there are more than 300 database calls.

Will this affect the speed of the cart as more users shop on the site?


Thanks

Dylan

[Kalamazoo]

Hi Dylan,

We have sites at well over thousands of products and 20,000 users with no problem. Make sure to review and clear out your SQL database at times such as the anonymous users, etc. I have found that most of this performance will be attributed to where you host and whether you have a semi-dedicated over a shared plan. Hosting with AbleCommerce is one good idea. But however you provide the proper gear you should enjoy excellent performance from this software.

All the best,

Phil Chrisman

[Shopping Cart Admin]

Hello Dylan,

I'd typed up this reply a couple of days ago, and wanted to get it 'vetted' by development before posting, but I'm sorry we've been too busy so I'll just post it.

Of course it will, but not when compared with other solutions .. we've been developing software for awhile now and although our feature set has gotten complex, we're consistently faster than our competitors and have been for a very long time. Take some time to review the quality of code compared to others and you'll find a substantial and thoughtful difference in our code.

With a large data set or user base there will be queries which will require a new index or a minor tweek here or there, based on your data and hardware limitations. Unless you have a ton of products and a close to nil conversion ratio with users that just like to hit refresh, AbleCommerce is going to do the job.

The only area I'm aware of right now that's a bottle neck is if you have a lot of records in your tax table (5000?) and you're using the built in tax methods. Mostly this is due to users being unable to write solid re expressions for their lockups. This is being corrected in 7.0.5, so that 'raw' row by row queries are more affective, when re expressions are not being used (this is a side effect of vat tax display).

We don't consider the admin side with 5,000 categories and 250,000 products as it's just not typical of our users to manage this via the admin and these types of category/product numbers are typically pushed into ablecommerce via other systems.

[krittleb]

I see this is a fairly old thread but relevant to us.

We are actually having performance issues with the shopping cart. There were several other issues our programmer thought could be causing the issue but they have been eliminated (mini-basket, volume discounts) and it is now down to just the actual shopping cart itself that could be causing the performance issues.

We currently have around 13,000 users and thousands of sku's. The problem is that many of our customers purchase over 50 unique line items per order and some well over 100 unique items. The site works wonderfully until around item number 40. It starts to slow and continues to get worse progressively. By 80 items, it is more than an annoyance, and over 100 likely to time-out after several minutes of processing.

We need some input on this right away as it is a major problem for us. BTW, we are hosting with a premium partner on our own dedicated server and they assure us it is absolutely not a server issue.

Thanks,
Kristi
http://www.hairbowcenter.com

[jmestep]

Kristi,
I think it's your variants. Vasilios and I were just on the phone about this and tested two other sites where we didn't have that problem adding 100 products to the basket. A lot of your products have variants with weight, price modifiers and inventory set. All those things could slow the add to basket down because they all have to be checked against and recaclulated when someone adds a product to the basket.
I just came to the forum to try to get some of Able's feedback on it.