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.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?
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.