I'm just curious, is there a method to access an auto-increment number in a newly inserted record without making another SOQL call? Something similar to how MySQL can call up the last insert ID after a query? I'm concerned that my trigger as written is going to run into the governors pretty quickly, so I'm trying to pare it down a bit.
Some background: I'm writing a trigger that is performing a round-robin assignment of leads based on certain criteria, so the correct portion of our sales staff gets assigned certain leads, and I'm using a custom object to keep track of what lead is assigned to whom. I have an auto-incrementing value on the records that I apply the modulus operation on, so I can assign the leads in turn when they come in. If anyone has any better ideas on how to accomplish this, I'm all ears.