Vince,
I dont think the application server should crash, well you could try
increase the page file size on NT Web Server where you are running CF and
what version Sql Database server are you running? Try installing the lastest
service pack v2 for Sql Server 7.0, 37000 is a known bug for ver6.5 (refer
microsoft site). I have returned more than 70,000 records from the database
at a time, how many records are you returning or processing and how much
memory do you have on NT Server?.
increasing the pagefile size itself might solve this...
control panel/System/performance!
Joe
------Original Message------
From: vincy <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Sent: May 17, 2000 1:34:15 PM GMT
Subject: RE: Re: what is ODBC 37000 error ??
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.
------------------------------------------------------------------------------
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.