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..
Jump to PostHi Steve,
Try doing indexing on ur tables it may help you.
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.