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 12621 Jan 13, 2010, 4:31 PM
Thread; hot thread Re: [delicia] script timing out
Andy 12428 Jan 14, 2010, 12:09 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12431 Jan 14, 2010, 8:07 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12426 Jan 14, 2010, 8:17 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12496 Jan 14, 2010, 8:25 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12416 Jan 14, 2010, 8:34 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12404 Jan 14, 2010, 8:37 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12405 Jan 14, 2010, 8:40 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12398 Jan 14, 2010, 8:47 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12400 Jan 14, 2010, 8:49 AM
Thread; hot thread Re: [Andy] script timing out
delicia 12429 Jan 14, 2010, 8:57 AM
Thread; hot thread Re: [delicia] script timing out
Andy 12397 Jan 14, 2010, 8:59 AM
Post; hot thread Re: [Andy] script timing out
delicia 12379 Jan 14, 2010, 9:01 AM