Gossamer Forum
Home : General : Perl Programming :

script timing out

Quote Reply
script timing out
i'm having problem sending emails to entire database of only 100 records from dbman. it times out after only about 50 records. this is what webhost says:


They are using CGI script that is trying to allocate too much memory.
We enforce extremely generous 50 MB memory limit per CGI process
instance. It looks like the script tries to load the entire database of
records into memory. It is a common programming error. It is also
possible that their record set had recently grown to the size and this
bug had manifested itself in this way. A much better way to write code
is to open db file and start processing records in it one at a time.

My recommendation is to find a better written list management CGI or fix
existing code.

FYI: They have a 50 MB sized core file inside cgi/db-private/ directory.
This is a clear indication that their "db.cgi" attempted to exceed that
memory limit.
i know nothing about sql or mysql etc. i've learned what little i know about perl from hacking dbman extensively. what should i do?
Subject Author Views Date
Thread; hot thread script timing out delicia 12450 Jan 13, 2010, 4:31 PM
Thread; hot thread Re: [delicia] script timing out
Andy 12259 Jan 14, 2010, 12:09 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12262 Jan 14, 2010, 8:07 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12257 Jan 14, 2010, 8:17 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12327 Jan 14, 2010, 8:25 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12247 Jan 14, 2010, 8:34 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12235 Jan 14, 2010, 8:37 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12236 Jan 14, 2010, 8:40 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12229 Jan 14, 2010, 8:47 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12231 Jan 14, 2010, 8:49 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12260 Jan 14, 2010, 8:57 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12228 Jan 14, 2010, 8:59 AM
Post; hot thread Re: [Andy] script timing out
delicia 12210 Jan 14, 2010, 9:01 AM