What Sql server version are you using?
Are you overiding any Constraint violations?
Primary key, foreign key etc
Doing all the looping, i guess would slow down the transaction
and might fail.
If you are searching through large junks of data and have parameters
for this, it would be apt to do this with a Stored Procedure.
How big is your returned dataset, could you do subqueries ? or
Joins , thats might speed up things,
but i guess it better to this using a Stored Procedure.
--- Original Message ---
vincy <[EMAIL PROTECTED]> Wrote on
Wed, 17 May 2000 18:00:48 +0530
------------------
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.
-----
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!
------------------------------------------------------------------------------
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.
