[Chicago-talk] perl DBI ?

[Randal L. Schwartz]

>>>>> "Richard" == Richard Reina <richard at rushlogistics.com> writes:

Richard>   However, not only would
Richard> it mean row level locking as more than one user would
Richard> need to be updating the table eventhough they are all
Richard> working on diff. transactions.,

Not sure what that means.  All records belonging to a user will
have a specific transaction ID distinct from any other row.

That's a transparent situation, I presume.  There's never be two
different processes both asking for a row with trans_id = 123, for
example.

So why have you listed this as a negative?

Richard>  it would just seem
Richard> much cleaner to compile the data for the transaction
Richard> as it's own table and discard it when the transaction
Richard> is done.

Any application that alter the schema on the fly is suspect.

-- 
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn at stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!