On 28 Sep 2011, at 3:41pm, Puneet Kishor wrote: > WHERE Datetime(u.downloaded_on) >= Datetime(p.project_start)
Why are you doing 'Datetime' here ? Not only does the conversion take time, but it means you can't usefully index either of those two columns. Can you instead store your stamps in a format which is readily sortable ? Either in text form or as julian days. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
