Re: fatal memory error after executing query on MSSQL server

From: Matthew Del Buono (PlzNoSpam_at_ToMe.com)
Date: 07/06/04


Date: Tue, 6 Jul 2004 11:43:01 -0400


"Johnny Geling" <johnny_rem*ove_this*_.geling@chello.be> wrote in message
news:2kvj9mF6l5qiU1@uni-berlin.de...
>
> Fatal error: Allowed memory size of 36700160 bytes exhausted
>
> Is the message I get when I execute a select query on a MSSQL database.
> De result set contains 2000 records of 4 fields.
>
> Using PHP on linux and connect using freedts with de MSSQL on a winnt
> server.
>
> I tried finding an answer using Google.
>
> The connection to the server is established. I can execute simple query
> on small tables. The table I my records from is typicaly large. There
> are measuring data stored in this table which are recieved every minute.
>
> What can I do?
>
> Thanks.

Can you post your code please? An error like this typically results from an
endless loop in a PHP script, or something of that nature. Think about it
for a second. 30MB is quite a lot of memory for a simple script to need --
even some very complex programs (i.e., my DVD burning program) doesn't use
that much. So your PHP script shouldn't need that much. Post your code here
so we can check it out.

-- Matt



Relevant Pages

  • fatal memory error after executing query on MSSQL server
    ... Is the message I get when I execute a select query on a MSSQL database. ... The connection to the server is established. ...
    (alt.php)
  • Re: fatal memory error after executing query on MSSQL server
    ... >> Is the message I get when I execute a select query on a MSSQL database. ... > an endless loop in a PHP script, ...
    (alt.php)
  • Re: php mssql stored procedure
    ... application that connects to a MSSQL database and executes a query ... Now if I execute this same query on the MSSQL server it runs just ... PHP ...
    (comp.lang.php)
  • php mssql stored procedure
    ... I am running PHP5.2.1 on a Windows 2003 server. ... application that connects to a MSSQL database and executes a query ... Now if I execute this same query on the MSSQL server it runs just ...
    (comp.lang.php)
  • calling query from memory?
    ... Is there a way of performing an sql query and then call it again from memory ... rather than having to execute the query again? ...
    (microsoft.public.inetserver.asp.general)