On Wed, May 7, 2008 at 5:25 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> > I couldn't see how these would be different so I fired up the explain > command. As I expected, these two produce identical code (except for the > integer id assigned to the ephemeral table used for the sort). I don't > think here will be any difference in speed between these two statements. > > sqlite> > > Dennis Cote > <http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > My bad--when I ran my tests I ran the second query through far less iterations than the first query (typo). Sorry for the misinformation. Sam -- ----------------------------------------------------------------- We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer. Position is in the Washington D.C. metro area. Contact [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users