ST Alpha - "and what do you want to do with it? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 152

In response to "It is a simple select." by GregW

and what do you want to do with it? -- nm

Posted by Beryllium (aka grayman) Aug 23 '12, 15:09

(No message)

Responses:

I am running a tool that extracts the data to my DB2 server where I will use it to load our new database. - GregW Aug 23, 15:14 4
- Really? It doesn't use disk files for sorting? -- nm - GregW Aug 23, 15:21 1
  - mysql might - but since you're invoking it from java, I think it's trying to create an in-memory result set that is too large -- nm - Beryllium Aug 23, 15:22
- You might want to forget java and just use mysqldump ... or even the mysql command itself to make a CSV -- (link) - Beryllium Aug 23, 15:19
- well, it sounds like what you're telling it to do is "select 200 million rows into RAM", which ... isn't useful. -- nm - Beryllium Aug 23, 15:17

Post a message top

Replies are disabled on threads older than 7 days.