hi,
yeah, well I've posting this problem all over the place, and on one seems
to be able to figure it out.
The thing is that part of the code in brief does this :
<CFloop1>
query
query
<CFloop2>
query
query
</lCFoop>
</CFloop>
Actually there are more queries. So, basically there are nested loops and
in that there are queries to the SQL server.
So, now if 500-700 people hit the site a day, I was wondering if this kind
of CF coding would choke the
SQL server !
vince
At 06:23 PM 5/17/00 +1200, David Cummins wrote:
>I don't actually know the answer, but if you do find out, let me know.
>
>One of our sites, the server (which is hosted by someone else) is chewing
>up 10k
>of memory every second for no known reason. They recently installed
>Service Pack
>6, or something like that.
>
>Luckily its not our problem, but its good to know these things...
>
>David
>
>vincy wrote:
> >
> > hi,
> > Im running my site on the coldfusion 4.0 server, with NT 4.0 and
> SQL 7.0
> > The strangest thing has been happening the last few days, Ive been
> > getting these
> > ODBC 37000 errors quite often. It says that there is not enough memory to
> > run the query.
> >
> > No one at the place that is hosting the site can figure out what page
> > is causing this.
> > They say that over a period of time the memory gets eaten up until it the
> > server runs out of memory.
> >
> > Im guessing that one of the pages that is used often is a page that has a
> > number of queries and loops to the SQL server .
> >
> > Anyone have any ideas on this ...Im running out of time. I cant have the
> > server crashing once in two days.
> >
> > regards,
> > vince
> >
> >
> ------------------------------------------------------------------------------
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
