So I loaded up TDA 2.7 and so far so good - except…
I’m editing a raw SQL query, and Toad helpfully pops up a window with the various columns in the table I’m selecting on - very nice, I like - but each column also has a + sign next to it - I’m assuming, so you can expand and see the various values in that column that you could select on. VERY BAD (at least in my case) - here’s why:
In an Oracle table (like I was working with) that has, literally, millions of rows, each with a unique value on that column, TDA 2.7 proceeded to consume ALL of my system resources before my machine finally hard locked and I had to force reboot. Not cool.
My question (since I can’t seem to find it)/suggestion is this: in the connection properties for the Database, provide us with an option to turn this loading off completely for the specified database, or even a program-wide option if the connection specific one won’t work.
I know enough not to click the + on purpose anymore - trust me! - but it could still happen by accident, and I can definitely see it happening to one of my coworkers who doesn’t know any better.
Just my $0.02