hi Joe,
Im using CF 4.0 enterprise server.
And not overriding any constraint violations.
--------
The first part of the code searches for the parent categories, then
searches for child categories.
Then totals all the items for sale in each category....
so on ...
------
So, these are the very basic of SQL queries that are involved.
But no doubt goes thru a series of loops.
As far as stored procedure goes, I may implement that in sometime.
But what I wanted to know is what really causes that dreadful -->
===========================
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.
============================
man!! I'm totally pissed getting that error ... and another one of those
will make me explode..
Incidentally, the server crashes once in 3 days ... so there is one due any
minute ! : )
VINCE
At 06:05 AM 5/17/00 -0700, [EMAIL PROTECTED] wrote:
>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.
------------------------------------------------------------------------------
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.
