• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Surfscience
#1 Posted : Monday, December 5, 2011 5:32:16 AM(UTC)
Surfscience

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
Aaron
#2 Posted : Monday, December 5, 2011 10:16:28 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
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
Kman
#3 Posted : Monday, December 5, 2011 12:34:35 PM(UTC)
Kman

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.
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
Aaron
#4 Posted : Monday, December 5, 2011 12:37:37 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Originally Posted by: "Kim (Kman)" Go to Quoted Post
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
Marcus
#5 Posted : Tuesday, December 6, 2011 9:13:06 AM(UTC)
Marcus

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.
Surfscience
#6 Posted : Tuesday, December 6, 2011 11:40:19 AM(UTC)
Surfscience

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?
Aaron
#7 Posted : Tuesday, December 6, 2011 12:12:24 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
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
Marcus
#8 Posted : Tuesday, December 6, 2011 1:19:44 PM(UTC)
Marcus

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.
Aaron
#9 Posted : Tuesday, December 6, 2011 1:35:19 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Originally Posted by: "Marcus" Go to Quoted Post
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" Go to Quoted Post
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
Marcus
#10 Posted : Tuesday, December 6, 2011 1:50:27 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

My mistake. I was saying "email" when I meant "username." MercantTribe just uses email.
Surfscience
#11 Posted : Wednesday, December 7, 2011 10:21:31 AM(UTC)
Surfscience

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.
Steve95
#12 Posted : Wednesday, December 7, 2011 10:48:26 AM(UTC)
Steve95

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" Go to Quoted Post
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
Dan @ Wolfe
#13 Posted : Wednesday, December 7, 2011 11:25:25 AM(UTC)
Dan @ Wolfe

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
Aaron
#14 Posted : Wednesday, December 7, 2011 2:23:35 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012