Re: [sqlite] How does SQLite treat repeated expressions?

nows about the inner > workings of SQLite - would suffice? > >> Date: Sun, 25 Oct 2009 10:08:01 -0500 >> From: punk.k...@gmail.com >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] How does SQLite treat repeated expressions? >> >> On Sun, Oct 25, 2

Re: [sqlite] How does SQLite treat repeated expressions?

the inner workings of SQLite - would suffice? > Date: Sun, 25 Oct 2009 10:08:01 -0500 > From: punk.k...@gmail.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How does SQLite treat repeated expressions? > > On Sun, Oct 25, 2009 at 9:49 AM, Igor Tandetnik <itandet...@m

Re: [sqlite] How does SQLite treat repeated expressions?

On Sun, Oct 25, 2009 at 9:49 AM, Igor Tandetnik wrote: > Kristoffer Danielsson wrote: >> A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); >> >> B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; >> >> Is statement B faster than A? Why?

Re: [sqlite] How does SQLite treat repeated expressions?

Kristoffer Danielsson wrote: > A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); > > B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; > > Is statement B faster than A? Why? Last time I checked, SQLite didn't perform any kind of common subexpression

[sqlite] How does SQLite treat repeated expressions?

Consider the two statements below. A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; Is statement B faster than A? Why?