Re: fatal memory error after executing query on MSSQL server
From: Matthew Del Buono (PlzNoSpam_at_ToMe.com)
Date: 07/06/04
- Next message: Matthew Del Buono: "Re: Please Recommend a Good Php Counter"
- Previous message: Phil Powell: "cURL doesn't get URL with required cookie"
- In reply to: Johnny Geling: "fatal memory error after executing query on MSSQL server"
- Next in thread: Johnny Geling: "Re: fatal memory error after executing query on MSSQL server"
- Reply: Johnny Geling: "Re: fatal memory error after executing query on MSSQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Matthew Del Buono: "Re: Please Recommend a Good Php Counter"
- Previous message: Phil Powell: "cURL doesn't get URL with required cookie"
- In reply to: Johnny Geling: "fatal memory error after executing query on MSSQL server"
- Next in thread: Johnny Geling: "Re: fatal memory error after executing query on MSSQL server"
- Reply: Johnny Geling: "Re: fatal memory error after executing query on MSSQL server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|