The record output buffer -- does it always work?

I have TOAD on XP (for now) and have the default record buffer still at 500 records. If I do a basic select * from table, the 500 works fine.

However, it seems like if I do a more complicated select from a join query (maybe one of the objects is even a subquery) it tries to dump all the (100Ks+!) of records back to the window… to the point where I get a memory overflow.

Are you executing the query with F5 or F9?