> > I suppose I could increase the JVM max memory to 2GB but I'm not
> > really sure if this is a viable option.
>
> No, it's certainly not an option on Windows generally, and
> probably not a viable option for solving this problem on any
> platform - that's just too big of a recordset. Do this
> I suppose I could increase the JVM max memory to 2GB but I'm
> not really sure if this is a viable option.
No, it's certainly not an option on Windows generally, and probably not a
viable option for solving this problem on any platform - that's just too big
of a recordset. Do this within the da
Garth Young wrote:
>
> 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.
Use a cursor:
http://www.houseoffusion.com/g
I'm trying to look for something in java but I'm not familiar with the ins adn
outs. I think the main problem is that I don't know the username and password
(for the eventual production environment). Would I be able to somehow reuse the
DSN used by ColdFusion to connect to the database?
~~
> I'm trying to look for something in java but I'm not familiar with the
> ins adn outs. I think the main problem is that I don't know the
> username and password (for the eventual production environment). Would
> I be able to somehow reuse the DSN used by ColdFusion to connect to
> the databas
omething, but I
really don't know what the options are here - maybe open a cursor?
Jaime Metcher
> -Original Message-
> From: Garth Young [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 25 July 2007 2:14 PM
> To: CF-Talk
> Subject: Re: Writing large data files
>
>
&
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 Co
>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
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
On 7/24/07, Garth Young <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>
9 matches
Mail list logo