rom: Torrent Girl [mailto:moniqueb...@gmail.com]
>>Sent: 20 June 2011 14:55
>>To: cf-talk
>>Subject: Re: Retrieve data in groups
>>
>>
>>
>>>Hi Torrent,
>>>
>>>Perhaps by running the query on the server using a stored proceedure?
>>
> In relation to this post, what does java heap space mean? I see this message
> is the log files. I looked this up on google and it appears that I am out
> of memory (?)
Yes, the Java heap is roughly analogous to the amount of memory
available to the JVM.
Dave Watts, CTO, Fig Leaf Software
htt
Yes, it means you are likely out of memory, probably because you are loading
too much database data into the server's RAM. You can reduce the amount of
RAM used by reducing the number of database columns or database rows
retrieved by the Web page that is running out of RAM.
-Mike Chabot
On Tue,
Others can address specifics. Meanwhile, you may want to Google "coldfusion
jvm tuning"
On Tue, Jun 21, 2011 at 9:47 AM, Torrent Girl wrote:
>
> >Hi All.
> >
> >Is there a way for me to retrieve records from a db in groups?
> >
> >I have a query that selects over 200,000 records and it times ou
>Hi All.
>
>Is there a way for me to retrieve records from a db in groups?
>
>I have a query that selects over 200,000 records and it times out on the cf
>output.
>
>Thanks
In relation to this post, what does java heap space mean? I see this message is
the log files. I looked this up on google
You are quite welcome... :)
-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com]
Sent: Monday, June 20, 2011 9:40 AM
To: cf-talk
Subject: Re: Retrieve data in groups
>If you want to update hundreds of thousands of records you might consider
>NOT using CF to do it
>If you want to update hundreds of thousands of records you might consider
>NOT using CF to do it. It's not always the best choice for really big import
>jobs.
>
>However - to answer your question... in the first case:
>
>SELECT TOP 10 ...
>
>
>You would need something in the where clause to
>Hi Torrent,
>
>Perhaps by running the query on the server using a stored proceedure?
>
>Take a look at this guide:
>
>http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html
>
>It looks so good I'll be using it myself, lol
>
>Jenny Gavin-Wear
>Fast Track eCommerce
>+44 (0) 1262 602013
>
>do you actually need all 20,000 records ?
>
>On Sat, Jun 18, 2011 at 12:22 PM, Jenny Gavin-Wear <
>jenn...@fasttrackonline.co.uk> wrote:
>
>>
yes, I need to update ALL of the records.
~|
Order the Adobe Coldfusion Anthology no
gh the query
To reiterate my warning though dealing with very very large updates
using CF may be a poor choice for a number of performance reasons :)
-Mark
-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com]
Sent: Monday, June 20, 2011 8:31 AM
To: cf-talk
Subject:
http://www.ftol-ecommerce.com/
>>-Original Message-
>>From: Torrent Girl [mailto:moniqueb...@gmail.com]
>>Sent: 20 June 2011 14:32
>>To: cf-talk
>>Subject: Re: Retrieve data in groups
>>
>>
>>
>>>Select TOP doesn't work in MySQL. You h
SELECT TOP 10 ... ORDER BY [reverse order of first 10]
or
or
On Mon, Jun 20, 2011 at 8:31 AM, Torrent Girl wrote:
>
> >SELECT TOP 10 ...
> >
> >or
> >
> >
> >
> >or
> >
> >
> >
> >On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl >wrote:
> >
> >>
>
> Thanks but what about the ne
>Select TOP doesn't work in MySQL. You have to use Limit 0, N where N=
>the number of records you want to return
>
>
>>> Any suggestions?
I am using MS SQL.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Ad
>SELECT TOP 10 ...
>
>or
>
>
>
>or
>
>
>
>On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl wrote:
>
>>
Thanks but what about the next 10. I need to update all of the records.
~|
Order the Adobe Coldfusion Anthology now!
h
>Select TOP doesn't work in MySQL. You have to use Limit 0, N where N=
>the number of records you want to return
>
>
>>> Any suggestions?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Antho
Track eCommerce
> http://www.ftol-ecommerce.com/
>
>
>
> >>-Original Message-
> >>From: Torrent Girl [mailto:moniqueb...@gmail.com]
> >>Sent: 17 June 2011 18:53
> >>To: cf-talk
> >>Subject: Retrieve data in groups
> >>
> >>
Coldfusion.
Hope this helps!
Jenny Gavin-Wear
Fast Track eCommerce
http://www.ftol-ecommerce.com/
>>-Original Message-
>>From: Torrent Girl [mailto:moniqueb...@gmail.com]
>>Sent: 17 June 2011 18:53
>>To: cf-talk
>>Subject: Retrieve data in groups
>>
>
Select TOP doesn't work in MySQL. You have to use Limit 0, N where N=
the number of records you want to return
On Fri, Jun 17, 2011 at 11:17 AM, John M Bliss wrote:
>
> SELECT TOP 10 ...
>
> or
>
>
>
> or
>
>
>
> On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl wrote:
>
>>
>> >Hi All.
>> >
There are many ways to do this, although some of the ways depend on which
database software you are using. The suggestions John made are a good
starting point.
Cfloop can handle as many rows as you want it to handle. If you are getting
a timeout, increase the timeout. 200,000 records is a reasona
SELECT TOP 10 ...
or
or
On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl wrote:
>
> >Hi All.
> >
> >Is there a way for me to retrieve records from a db in groups?
> >
> >I have a query that selects over 200,000 records and it times out on the
> cf output.
> >
> >Thanks
>
> I don't think
>Hi All.
>
>Is there a way for me to retrieve records from a db in groups?
>
>I have a query that selects over 200,000 records and it times out on the cf
>output.
>
>Thanks
I don't think I asked this right. What I need to do is encrypt user passwords I
need to do it in CF. Problem is there are
Hi All.
Is there a way for me to retrieve records from a db in groups?
I have a query that selects over 200,000 records and it times out on the cf
output.
Thanks
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.
22 matches
Mail list logo
