Joe,
Thanks, I give that a try.....
We are using SQL 7 .No patch. NT4 with SP6a. and CF4.(a patch
required??)Could that be the prob??
By increasing the page file on the NT server would just give us more room.
According to the people that are hosting our site, they say that once the
site starts getting hits
(approx 500-1000 a day) there is a gradual increase in the memory usage.
The amount of memory that is used
doesn't seem to reduce. And around the next day all the memory is used and
then we get the
SQL 37000 error. Not enough memory to run the query.
In any case I try your suggestion and I get back to you..
thanks again,
regards
vince
At 12:42 PM 5/17/00 -0400, Joseph Eugene wrote:
>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.
------------------------------------------------------------------------------
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.
