Memory Issue would someone confirm

2007-09-04 Thread Michael Dykman
Perhaps if you show us the table structure and exactly what operations you are using, we might be able to provide some insight.. as it is, your report is too vague to make much sense of it. - michael On 9/4/07, Justin <[EMAIL PROTECTED]> wrote: > alright.. after some testing this afternoon I'm

Re: Memory Issue would someone confirm

2007-09-04 Thread Justin
table_cache. - Original Message - From: "Justin" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 04, 2007 1:46 PM Subject: Memory Issue would someone confirm alright.. after some testing this afternoon I'm beginning to wonder if this is a memory issue.. here's w

Memory Issue would someone confirm

2007-09-04 Thread Justin
alright.. after some testing this afternoon I'm beginning to wonder if this is a memory issue.. here's what the test was.. I did a insert select from a table that has approx 500,000 rows and the table data is about 1gb in size.. the query went and was in the repair by sorting phase when all of