ST Alpha - "GregW: How big is the field you are sorting on, or what datatype is 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

GregW: How big is the field you are sorting on, or what datatype is it? -- nm

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

(No message)

Responses:

a view lets you work with just a few fields at a time, plus you can include data from joins so you're looking at the exact info you need. I suppose th - zork Aug 23, 14:35 2
- also the view can include a filter like the one you wanted (specific records) or a certain value(s) in a field(s) -- nm - zork Aug 23, 14:37 1
  - Yeah, the goal of SQL as a whole is to get the database to do all the crunching for you, so you only have to deal with the final report output -- nm - Beryllium Aug 23, 15:01
It is varchar(22). I don't know why I can't run it with Order By, by I keep getting this error: - GregW Aug 23, 14:15 11
- bad permissions on /data01/tmp ? -- nm - zork Aug 23, 15:09
- what is the query that causes that error? -- nm - Beryllium Aug 23, 15:01 7
  - It is a simple select. - GregW Aug 23, 15:05 6
    - and what do you want to do with it? -- nm - Beryllium Aug 23, 15:09 5
      - 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
- Are you creating temp tables? -- nm - JaxSean Aug 23, 14:20 1
  - No -- nm - GregW Aug 23, 14:29

Post a message top

Replies are disabled on threads older than 7 days.