[sahana-maindev] possible uuid issue

[dinusha k. <kum...@ya...>]

hi All

as you know sahana provides a unique id for each
record/row using a function to generate a unique id
for each instance...

If several users(say..several hundred users ) enter
values at the same time there is a possibility that
the same uuid is given to two or more different
records.

if we implement a mechanism to lock the
shn_create_uuid()
function until a guuid given to particular record and
the n release the lock, the problem might get solved.


we are using mysql as the primary database server
which does not support sequences natively..so the
ADOdb genuuid() will automatically create a uuid
table...since this is an automated process,if
something goes wrong with the uuid generation it might
lead to a corruption to database tables

any ideas or suggestions will be highly appreciated..

thanks and regards
dinusha




 
____________________________________________________________________________________
Don't get soaked.  Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather