High Ram Consumption.

[ashfaq_haseeb]

Dear all

I have two tables joined by left join

Table-1 have 230,013 records

where as table-2 have 239,992 record

all of them fetched data from database but before giving compleation message it taking too much time and ram utilization increases I have 8 gb of ram, and after fetching data and before giving sucessful reload message it consumes all 8 gb ram.

and gives me an error " ODBC" connection fale.

I'm working on SR4 Desktop Edition.

Is this error due to any bug in SR4. Or there is some logic behind

thanks in advance

Regards

Ashfaq

[ashfaq_haseeb]

Thanks @ Ashish and Karl

Both of your inputs were helpful.