On Sun, May 17, 2009 at 1:30 PM, Wes Wannemacher <w...@wantii.com> wrote:
> That is generally a bad idea. Select max(row) will generally initiate > a full index scan or, even worse, a full table scan. > Isn't it a greater problem that this approach is a race condition? 2 threads call max(id) about the same time and then try to insert max + 1 one just after the other. -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:da...@6degrees.com
