Hi, I'm working with some VERY large databases and running a join. After a while, I get an out of Memory error because the results in memory grow too big. What are some work arounds? I'm using PostgreSQL. I've heard of a method that uses fetch and limit, but I can't use an external program to detect when 0 lines are turned.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.