system resource exceeded

  • Thread starter Thread starter ody
  • Start date Start date
O

ody

Hi guys, please help me with this.. when I run my query
for 5 hours, it always gives me an error message in the
end " system resource exceeded"
How will I be able to solve this?
 
5 hours???

I have some exceedingly large Tables ( > 1 million Records) and can't recall
any Queries that take more than few minutes to process.

I would suggest if you call some functions in your Query, check for infinite
loops.

Perhaps you should post relevant details of your Tables and the SQL String
of your Query.
 
Back
Top