Home
Contact
Blog
Articles on this page...
Archives
<
February 2012
>
Sun
Mon
Tue
Wed
Thu
Fri
Sat
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
1
2
3
4
5
6
7
8
9
10
Aggregation:
Categories
Blogging (2)
Development (10)
Hardware (7)
MySQL (3)
Server Administration (2)
SSD (2)
Storis (1)
UniData (1)
Virtualization (1)
Windows 7 (5)
Windows Mobile (1)
October, 2009 (2)
June, 2009 (2)
May, 2009 (3)
March, 2009 (4)
February, 2009 (3)
December, 2008 (4)
November, 2008 (4)
Blogging
Development
Hardware
MySQL
Server Administration
SSD
Storis
UniData
Virtualization
Windows 7
Windows Mobile
Blogroll
Scott Hanselman
Pick a theme:
BlogXP
business
calmBlue
Candid Blue
Continuum
dasBlog
dasblogger
dasblueblog
dasEmerald
DirectionalRedux
Discreet Blog Blue
Elegante
essence
Just Html
MadsSimple
Mobile
Mono
Movable Radio Blue
Movable Radio Heat
nautica022
orangeCream
Portal
Project84
Project84Grass
Slate
Sound Waves
Tricoleur
useit.com
Voidclass2
Sign In
Wednesday, May 20, 2009
« Edit Text in a .NET Assembly
|
Main
|
SSD Performance in a Laptop »
MySQL ODBC Slow - Caused by Nod32 4.0
I noticed that my web app, which makes anywhere from one to many MySQL connections per page was running slowly on my new Windows 7 RC laptop. I used dotTrace to compare the page execution to that of my desktop (which runs the app very quickly) and noticed that it was all the MySQL connections that were taking 10x to 100x as long to execute on the laptop.
After a bunch of troubleshooting I finally determined what was causing the performance problem. It was Nod32 4.0. I couldn't just disable Nod32, though. I had to completely uninstall it to cure the MySQL ODBC slowdown!
With Nod32 4.0 installed, some pages were taking 13 seconds to execute.
Without Nod32 4.0 installed, those same pages were taking less than a second to execute.
I observed this behavior on two systems:
Dell Inspiron E1705 w/ Windows 7 RC x86
Dell Studio 16 XPS w/ Windows 7 RC x64 (happened with both 64-bit and 32-bit ODBC drivers, and with both 3.51 and 5.1 versions of each)
Both systems have Windows 7 so this could be a problem only for Windows 7 users with Nod32 4.0. Maybe it's fine with Vista or some other anti-virus application. I hope this helps someone because it took me FOREVER to figure out it was Nod! I sent their support an email explaining all this. Hopefully they will write back with some info. Aside from this, which is a DEALBREAKER, I love Nod32 :(
Development
|
MySQL
|
Windows 7
Wednesday, May 20, 2009 1:02:25 AM (Central Daylight Time, UTC-05:00)
Comments [0]
Related posts:
PLINQO is the best way to use LINQ to SQL
Baskin Robbins I Fixed Your Logo For You
Remote Desktop Connection Does Not Remember Window Size or Position
Delete OEM Partition
SSD Performance in a Laptop
Edit Text in a .NET Assembly
All comments require the approval of the site owner before being displayed.
Name
E-mail
Home page
Remember Me
Comment (Some html is allowed:
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u
) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview
Copyright © 1998 - 2008, Continuum Concepts, LLC.
Phone: (214) 564-2608. Fax: (435) 304-1859. Email:
chris@continuumconcepts.com