Re: memory limit exceeded

the time limit is set to 0 in the php.ini file (infinity). i've also tried it with the time limit set to 2 hrs etc. - the same error. On Wed, 19 Jul 2000, Hans H. Anderson wrote: > Gunjan, > > So it sounds as though it's choking on the query... the query takes too > long and the maximum time is exceeded. This could be a database problem, > too. You can get around it by using the set_time_limit(0) command at the > top of the script, but it doesn't really cover the problem. > > Check out your database, make sure you are querying it properly. If you > are using MySQL, check out the "explain" syntax, it's helped me a bunch > when I've really needed to optimize queries. > > If it just turns out the script needs all the data, and it just plain > takes awhile to get it, you could try the set_time_limit command and > output some HTML telling users to be patient. > > I'm going on vacation in about 4 hours, so I probably won't be able to > help any longer. Sorry. > > Hans > > On Thu, 20 Jul 2000, Gunjan Kapoor wrote: > > > > > Hi, > > I'll try to explain the problem more clearly. I don't suppose you'd need > > the script, but if you do, please let me know. I really want to know > > what's going on. > > > > step 1: execute script so that it retrieves 2 yr data. Execution > > successful. > > > > step 2: execute script so that it retrieves 2 yr data. Execution > > successful. > > > > step 3: execute script so that it retrieves 7 yr data. Execution > > fails -- memory_limit exceeded. > > > > step 4: execute script so that it retrieves 2 yr data. Execution > > fails -- memory_limit exceeded. > > > > step 5: execute script so that it retrieves 1 day data. Execution > > fails -- memory_limit exceeded. > > > > > > > > > > > Gunjan, > > > > > > There are so many things that could be going on that I cannot possibly > > > account for them all without a little more to go on. Can you narrow it > > > down by sending a script, or a part of one? > > > > > > > > Hans Anderson ~ me@hansanderson.com > PO Box 426, Missoula, MT 59806 | PHP, Search Engines, SQL > (800)397-9116 / (406)549-6524 | Databases, Flash Multimedia, > http://www.hansanderson.com | Killer Audio Production, > http://www.goofiness.com | Minty Fresh Breath. > >