[TYPO3-dev] Temporarily Closing Typo3 Database Connection

Mathias Schreiber [wmdb >] mathias.schreiber at wmdb.de
Mon Mar 16 14:05:40 CET 2009


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?

Could you get into a little more detail?
Because I don't get why you close te connection to the database at all?
Are two different databases involved?

cheers
mathias




More information about the TYPO3-dev mailing list