Re: [sqlite] Auto Increment?

[Dennis Cote]

Jim C. Nasby wrote:

On Tue, Jan 31, 2006 at 10:05:47AM -0700, Dennis Cote wrote:
 

[EMAIL PROTECTED] wrote:
CREATE TABLE x(i INTEGER PRIMARY KEY AUTOINCREMENT CHECK(i < (1<<32)));
   


I suspect you'll see better performance if you hard-code the value
instead of doing a bit-shift every time you insert.
 

Jim,

You are correct, at least until Richard finishes his constant 
subexpression folding optimizations. :-)

Dennis Cote