fatal memory error after executing query on MSSQL server

From: Johnny Geling (johnny_rem*ove_this*_.geling_at_chello.be)
Date: 07/06/04 

Date: Tue, 06 Jul 2004 14:12:37 +0200

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.

Relevant Pages

  • 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. ... 30MB is quite a lot of memory for a simple script to need -- ...
    (alt.php)
  • Re: Action pass-through with a form variable Access 2003
    ... variables don't exist on the server where it will execute. ... You can use variables in a regular query that will first be processed by the ... Jet or ACCDB database engine before being handed over to the ODBC driver. ...
    (comp.databases.ms-access)
  • Re: Action pass-through with a form variable Access 2003
    ... You can't "integrate variables into a pass-through query" because those ... variables don't exist on the server where it will execute. ...
    (comp.databases.ms-access)
  • Re: [PHP] how to curl
    ... i have a few questions as well; is the query being executed on the provider ... consumer (the one you intend to execute the curl request from)? ... Yes I'm doing on the both the server. ... And when a consumer server will send ...
    (php.general)
  • Query governor problem
    ... advanced server and Windows 2003 server. ... The query will normally execute in less than a second. ... the cpu estimate used by the query governor will always be for the ...
    (microsoft.public.sqlserver.server)