I am trying to export 52,000 rows as a csv from mysql. I can do this using MySQL Query Browser in a second or two. Toad is taking several minutes and fails often. I assume that I am doing something wrong since I am a new user of TOAD.
I am have created the attached Export_HH_Pattern_Color.tas to export my csv. This connects to my DB and then uses the Export Wizard which connects to my DB and then runs the attached Export Wizard HH_Pattern_Color.txp.
This process runs for several minutes and often fails. I can export the same data using MySQL Query Browser in less than 2 seconds.
Any assistance you can provide would be greatly appreciated.