Performance Tidbit..

[Angel]

I recently discovered something which seemed a bit odd...wondering if anyone else has had similar experiences ...

A little background on my system:

- Pentium 4, 1.6 Ghz Laptop with 768 MB RAM, Windows XP SP2, XAMPP stack with Sugar 4.5h Open Source

It is not a super speedy machine, but it gets the job done. However, it always seemed to me as though Sugar ran slower than expected on it, even when the MySQL and Apache server were hosted elsewhere on our LAN.

I never really looked into the reasons why, but by accident, I appear to have found a large portion of the reason for the slowness.

My machine also has MacAfee 8.5 Enterprise installed. When I disabled it for other purposes, my Sugar performance literally doubled.

It normally would take about 10 secs for me to pull up the Accounts ListView. With AV disabled, it takes me approx 4 secs.

I am not exactly sure why MacAfee is affecting it so much (need to investigate that further), but it seems rather strange, especially give that my normal web browsing doesn't seem to suffer from the same problem. Perhaps it is some interaction between MySQL and MacAfee. Weird.

Has anyone else noticed anything along these lines?

Anyone else out there that could give it a try to see if they see the same behavior?

[andydreisch]

Angel, thanks for this. I've asked Jacob to comment.

Andy

[Angel]

Thanks Andy.

BTW, I spent some more time looking at the issue this afternoon and narrowed it down to the script scanning capabilities of McAfee.

If I just disable script scanning, performance is even better than when I disable real time/on access scanning.

Perhaps you can add this to any documentation pertaining to performance.

[andydreisch]

Absolutely, Angel.

In fact, Jacob's Performance and Clustering SDUG is tomorrow (Wednesday), February 7th, at 9am PST.

You'll more than likely hear this in that session as well!!

Andy

[mycrmspacegunnar]

Thanks Andy.

BTW, I spent some more time looking at the issue this afternoon and narrowed it down to the script scanning capabilities of McAfee.

If I just disable script scanning, performance is even better than when I disable real time/on access scanning.

Perhaps you can add this to any documentation pertaining to performance.

This behavior is normal for all Virus protection products that provide some sort of "internet security". These poduct proxy and scan all webrequest which slows them down a lot. Often they even alter header information which can prevent you from caching the web objects. In one of the performance threads on this forum we gave an example that users with active Norton Internet Security can expect a major slowdown >500% when using Sugar.


Cheers
Gunnar

[andydreisch]

Hi mycrmspacegunnar, while it's obvious what an AV system needs to do, it's not so obvious to me why it exacts a 200-500% performance hit to do so.

Jacob will be delivering a Performance and Clustering session just this morning and, given that he worked at Symantec at one time, he might have a particular angle to this.

Andy

[Angel]

Hi mycrmspacegunnar, while it's obvious what an AV system needs to do, it's not so obvious to me why it exacts a 200-500% performance hit to do so.

I agree. Some degradation would be expected, but 200 - 500% seems excessive, especially when other web surfing appears to behave normally.