On Mon, 2007-07-16 at 16:47 -0400, Ahmed Sulaiman wrote: > Hi all, > > Is it necessary to run a "SELECT" command in between a transaction? I > have few places in my code where I have a command that reads some data > from a table, and I wonder if I should begin/commit a transaction? Is > there any performance issues if I did or didn't do that?
It's not necessary, and unlikely to have a noticeable effect on performance. This decision should be made based on the logical requirements of the system (i.e. is it important that SQL statements executed after the SELECT operate on a consistent snapshot of the database). Dan. > Regards > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------