Re: Bug on MySQL? timestamp problem

[CountZero]

Something else entirely.

From your code I gather that you must have first SELECT-ed the number of views this news-item had before ($current_views). Then your sub updates (increments) the number of views.

However, you seem to re-connect to the database ($dbh = BaboonDB->connect()) to do this, although presumably you just made a connection (to get the current number of views of this news-item). Did you disconnect from the database after getting the number of views? I don't think it is necessary to disconnect and re-connect at such short intervals as connecting is a fairly "expensive" operation and it will slow your script down.

My suggestion is to do one connect at the beginning of the script and one at the end. Or even (if you are using an Apache server), to use Apache::DBI to pool/cache your connects.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law