On 9. Apr 2007, at 06:42, Bob Henkel wrote:
[...] The test case I used was to execute the command on a query that returns about 140,000 rows with about 4 columns of data so pretty skinny data overall relative to typical database data.
Sure, but not skinny compared to what you typical *return* from a database query (and show in a web browser, which the HTML output mode basically is).
Is there any way to make TextMate not consume the machine during the executing of this command.
Since this is a problem with the HTML output window, i.e. WebKit, you could write a custom view (i.e. nib) for displaying the output. But even an NSTableView becomes sluggish with 140,000 rows (although it doesn’t cause swapping).
Maybe only show X amount of row instead of all the data?
Like adding “LIMIT x” to your query? Yes, you could also do that ;)