If your result set is bigger than the JVM size, then yes, there is no way you're going to be able to do anything unless you break it into smaller pieces or increase the JVM size.
On 7/25/07, Garth Young <[EMAIL PROTECTED]> wrote: > > >I have released a UDF over at cflib.org, that will convert a ColdFusion > >query to "CSV" using JavaString Buffer which is considerably faster. > > > >http://www.cflib.org/udf.cfm?ID=1197 > > > >Thanks and let me know if you have any problem. > > > >Qasim > > > > > >> > > The problem I have is that the Coldfusion query is not returning as the > result set is too big. I could simply run the query pulling out blocks of > rows from it but this would require re-executing the SQL 6-7 times at least. > > I suppose I could increase the JVM max memory to 2GB but I'm not really > sure if this is a viable option. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
