|
Replies:
0
-
Pages:
1
|
|
|
Posts:
2
Registered:
8/15/12
|
|
|
|
SLOW - Export mysql data to csv using Automation Scripts
Posted:
Aug 15, 2012 10:24 AM
|
|
|
|
|
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.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
