Re: sequences and Postgresql

[prev] [thread] [next] [Date index for 2004/07/08]

On Wed, Jul 07, 2004 at 10:13:55PM -0400, Dana Hudes wrote:
> I thought I had sent the respone to the list but in fact I didn't so I 
> have gone back and resent it there.
> As for suboptimal -- I made the case , such as it is, already.
> I haven't time to measure the difference in performance but clearly there 
> is a difference in running extra Perl code (_prepopulate_id and that in 
> turn calls Ima::DBI eventually which calls DBI which goes to the 
> database...and then all those layers back up) and database activity.
> One user on a data entry system with a web i/f incurring one extra 
> transaction is not going to see the difference. A busy e-commerce site 
> with 5-10 transactions/second, yes.

Having run a busy ecommerce site with well over 5-10 transactions a
second, I'm not sure I'd agree with your conclusion, but that's not th
epoint.

Perhaps you could explain what should happen?

Tony