On May 25, 2006, at 8:35 PM, John Siracusa wrote:
Do you have any ideas about how to do so?
-John
Well it would depend on RoseDB supporting the dynamic variable
setting that you had contemplated earlier...
Since rosedb supports transactions, i'd imagine it would work easily
like this:
$db = MyApp::DB->new( timed_transactions=>1 );
or
$db->begin_work( timed_transactions=>1 );
whenever a begin_work hits the database, one would just do:
$self->_transaction_start = &sql_query( "SELECT NOW()" );
and then whenever an insert/update happens with a NOW() or to a
timestamp column, catch it with a regex or the class definition and
sub in the _transaction_start timetstamp
it would be a performance hit, undoubtedly -- but it would be an
option based on a boolcheck, which shouldn't be perceptible at all to
those who don't want it.
I'm an ecstatic postgres user now though -- and in postgres land this
is one of those great things we've got. in mysqlworld, no one really
thinks about stuff like that, so it could very well be something that
people don't care/want.
//Jonathan Vanasco
|- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - -
| RoadSound.com / Indie-Rock.net
| Collaborative Online Management And Syndication Tools
|- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - -
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
