[TYPO3-dev] Temporarily Closing Typo3 Database Connection

[Martin Kutschker]

Frank Weindel schrieb:
> Hi all,
> 
> We've got a cli module that sends out mass mailings to subscribed users.
> The database is first queried to find out what specific mailings need to
> go out, and then they are sent out one after another. We've got 20000+
> people subscribed so the actual sending takes upwards 30 minutes or more.
> 
> The problem is after each batch sending we need to update the database
> to let it know the mailing went out successfully, and by that time our
> connection to the database has timed out. Our ideal solution is to close
> the Typo3 database connection before sending out a batch mailing and
> then reestablish the connection afterwards. The t3lib_DB class doesn't
> seem to provide for this ability, it does not even seem to have a
> wrapper method to call the mysql_close() function.
> 
> Is there any recommended way to do this?

Try mysql_ping().

Masi