troubleshooting Question

MySQL indexes

Avatar of AWestEng
AWestEngFlag for Sweden asked on
.NET ProgrammingVisual Basic.NETEditors IDEs
2 Comments1 Solution242 ViewsLast Modified:

I have a question regaring indexes in MySQL.

When I insert data I have read that is good to turn them off

But is that still ok if I have records that already exists in the database that i'm going to insert agan.

I use the On Duplicate Insert so is it still ok then even if I turn the indexes off?

And how do I turn it off? do I need to do something more then turn it off and then on again. do I need to do any optimize,flush etc?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
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 1 Answer and 2 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