BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Slow performance when logging into Admin (i.e. when encryption keys are loaded)
Rank: Member
Joined: 2/7/2006(UTC) Posts: 66
|
I don't know if it is just my confirguration but when the encryption keys were added to BVC5 (with the 'PCI Complient' update) there has since been a marked delay in logging into the admin section of the site. This delay doesn't seem to manifest itself anywhere else except when logging into the admin section.
I'm running on a brand new, fast windows box and in all other regards the site runs VERY quickly. I have two BV sites on the same server; one running BVC5 3.2 and one running 5.8. The pre-PCI complient 3.2 store logs into the admin instantly, the 5.8 store (and all previous versions since the PCI complience was added) exhibits this 5-10 second delay when logging in. It might not sound like much of an issue but because we use the Admin > New Order section to take telephone orders it can be quite frustrating stalling a customer on the phone for 10 seconds before we can start taking their order.
Has anyone else experience this? - Like I say, it could just be my configuration so any help or suggestions would be appreciated.
Best regards, Matt |
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Matt,
BV's admin is very inefficient on certain pages, one of which is the Dashboard (the two other bad offenders are the Catalog main page and the Order Manager). The Dashboard page is easy to fix, though. All you need to do is remove the "Order Activity" Content Block(s) from the Content Columns on the Dashboard. This control is very inefficient in the way that it returns data. Depending on your order volume and whether you're taking your orders through all of the status (i.e. paid, sipped, complete) you will see some serious performance problems. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 11/25/2003(UTC) Posts: 370
|
Wondering if this has anything to do with JIT compiling in admin for version 5. I question this as I just looked at a clients site and nothing in admin takes longer than a second to load. This is a dedicated box with 8gig mem and pretty active during business hours in admin. |
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "Kim (Kman)" Wondering if this has anything to do with JIT compiling in admin for version 5. I question this as I just looked at a clients site and nothing in admin takes longer than a second to load. This is a dedicated box with 8gig mem and pretty active during business hours in admin. That's true if the delay is only on the first visit. The slowdowns I'm referring to are code-related and happy on every page load. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 1,786
|
BV5 pulls RSS news feed from our servers in older versions and that can also cause a slight delay that is blocking on the dashboard. We use an iframe in MerchantTribe so any loading isn't blocking.
|
|
|
|
Rank: Member
Joined: 2/7/2006(UTC) Posts: 66
|
Thanks for the feedback.
The slowdown is *only* when I need to log in to the admin - if I keep coming in and out it's fine; it's only when I get logged out because of inactivity and then log back in. Once logged in I can move in and out of the admin very quickly. Would the JIT compiling compile every time I have to log into the admin? Surely this would only be on the first execution of the page after a change? |
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
As long as the app pool doesn't recycle a page should only be JIT-ed on the first visit to it. Your IIS settings may be causing the app pool to recycle more than normal. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 1,786
|
It could be indexing on the email field of the useraccount table. The login is going to scan for a user account matching your email which is a text field match (slow). You can check your SQL server and see if you have an index in the email column of the useraccount table. If not, add one and you'll probably see things move faster.
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: "Marcus" It could be indexing on the email field of the useraccount table. The login is going to scan for a user account matching your email which is a text field match (slow). BV 5's login uses a username (which has an index), not an email address. Am I missing something? Originally Posted by: "Marcus" You can check your SQL server and see if you have an index in the email column of the useraccount table. If not, add one and you'll probably see things move faster. BV 5's business logic doesn't enforce unique email addresses, so if you do this it either won't work (since you already have duplicates) or it will lead to an error down the road when a user tries to create another account with an existing email address. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 1,786
|
My mistake. I was saying "email" when I meant "username." MercantTribe just uses email.
|
|
|
|
Rank: Member
Joined: 2/7/2006(UTC) Posts: 66
|
Just out of interest I went with one of Aaron's suggestions from earlier in the topic which was to remove the Order Activity and the RSS feed from the dashboard. Logic tells me that if it's a problem with the efficiency of the code of these modules then I should see the slow performance every time (when in fact I don't) but low and behold it has fixed the problem right away! - I can now log into the admin instantly, just like I can with the older versions of BV. What is strange is that the older build of BV does have the Order Activity on the dashboard and that doesn't seem to have any of the same performance issues. Anyway, my problem is fixed, for anyone else with performance issues when loading the dashboard I can certainly recommend following Aaron's tip of removing the Order Activity and RSS (I'm not sure which had the most impact but since I don't really require either then I just knocked them both out).
Thanks again for the input folks, it's nice to see the forum being well supported at the moment. |
|
|
|
|
Rank: Member
Joined: 4/29/2010(UTC) Posts: 256
Thanks: 4 times Was thanked: 11 time(s) in 10 post(s)
|
Originally Posted by: "Marcus" BV5 pulls RSS news feed from our servers in older versions and that can also cause a slight delay that is blocking on the dashboard. We use an iframe in MerchantTribe so any loading isn't blocking. I would have to agree with this, just removed the RSS news feed and it’s speeded up the Dev environment no end
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC) Posts: 298
|
I agree as well, removed the RSS feed and the load time speed up for the first instance. |
Dan |
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Matt, Steve, and Dan,
Sounds like the RSS feed Content Block was the performance problem for you guys, not the Order Activity block as it has been for some of our clients. I wonder if BV's site, which serves the RSS feed, is what's causing the slowdown. The reason it only is slow on the first visit is because the RSS feed Content Block caches the feed after the initial load. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
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.