On Sun, May 17, 2009 at 1:30 PM, Wes Wannemacher <[email protected]> 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:[email protected]
