Paul wrote: > CREATE TABLE bar( > id INTEGER PRIMARY KEY, > foo TEXT UNIQUE, > ) > > SELECT 1 FROM bar WHERE foo = ? LIMIT 1; > > is statement builder is smart enough to render "LIMIT 1" suggestion useles
No, the LIMIT 1 logic is never removed. > if we take into account the fact that these are extra characters and tokens > that parser must waste CPU cycles/RAM on? The difference probably is too small to be noticed. Regards, Clemens