Dne 17.3.2011 19:29, Davenport, Julie napsal(a):
> I have not yet had time to try Tomas' suggestion of bumping up the work_mem first (trying to figure out how to do that from within a coldfusion script). Many thanks for all your help guys!
Well, just execute this 'SQL query' just like the other ones
set work_mem='8MB'
and it will increase the amount of memory for that connection.
Tomas