troubleshooting Question

odbc vs ole db which is faster

Avatar of Autoeforms
Autoeforms asked on
MySQL Server
8 Comments2 Solutions411 ViewsLast Modified:
I inherited an application that utilizes odbc to connect to mysql.

everything is running fun and dandy but somethines i see slow queries. I monitor everthing (slow being just over .5 seconds) on tables that have fewer then 1000 records.

note everything is properly indexed.

how much if any performance improvement will i see using ole db.

mysql is 4.x hosted at go daddy
and they are running 1.1 of the frame work

i access the data through web services.

thanks for any tid bids. I am the sole developer and any and all help is appreciated. I can only do so much research

Greg
ASKER CERTIFIED SOLUTION
chigs20

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros