RE: temporary space - doesn't scale?

If you do not have tempdbs defined, all sort/order by etc goes in you /tmp. take a look if your /tmp is not running out of space. -----Original Message----- From: Matthew Cornell [mailto:cornell@cs.umass.edu] Sent: Wednesday, December 13, 2000 9:29 AM To: informix-list@iiug.org Subject: temporary space - doesn't scale? Hi Folks, We're running IDS.2000 (9.21.UC3-2) on RedHat Linux 6.2, and our program is running out of temp space (-229: Could not open or create a temporary file.) What bothers me is I've allocated a 2GB dbspace for temporary usage, but I'm running the program on our "tiny" database (6000 records). I'm thinking there is no *way* informix will scale to our "small" database of 1M records. It seems to me that the engine is a hog when it comes to space usage - I guess they traded space for time? How are others getting around this problem? Here's the query, FYI: SELECT P1.item_id, P2.item_id, date, time, quantity, trans_label FROM av_2 P1, av_2 P2, training_data_fully_labeled WHERE P1.value=training_data_fully_labeled.origin AND P2.value=training_data_fully_labeled.destination Thanks. matt