Is there any way that i can be able to get the ExecutenonQuery to Execute faster. Am using it to run mysql queries that have joins from diffrent tables. As I have come to notice, the user has to wait a while before the statement ExecutenonQuery can be completely executed.. is there any way that I can get it to execute faster?
Any help will be highly apreciated..
Hi Steve,
Try doing indexing on ur tables it may help you.
Hi Steve,
You know, I had the same problem and after a lot of debugging I found the
ExecuteNonQuery took only 0.2 seconds, but the .Connection.Close() took over a second. I marked that line as comment and the program is running fast as lightning. I'm not sure it's a good idea to let the program handle the closing but till now, I don't see any problems. (The program runs for a few days in testing-phase so maybe it will turn out it isn't a good solution, but for now : perfect)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.