On Thu, Mar 13, 2014 at 7:50 PM, Andreas Kupries <andre...@activestate.com>wrote:
> WIBNI regardless of which form is faster, the engine would detect and > rewrite the slower into the other ? > i wouldn't quite expect the engine to figure that out, but of course would be happy if it could. > Note: Which is faster might depend on if we have an index on the mtime > field or not. > Now that you mention it... CREATE TABLE event( type TEXT, -- Type of event: 'ci', 'w', 'e', 't', 'g' mtime DATETIME, -- Time of occurrence. Julian day. objid INTEGER PRIMARY KEY, -- Associated record ID tagid INTEGER, -- Associated ticket or wiki name tag uid INTEGER REFERENCES user, -- User who caused the event bgcolor TEXT, -- Color set by 'bgcolor' property euser TEXT, -- User set by 'user' property user TEXT, -- Name of the user ecomment TEXT, -- Comment set by 'comment' property comment TEXT, -- Comment describing the event brief TEXT, -- Short comment when tagid already seen omtime DATETIME -- Original unchanged date+time, or NULL ); CREATE INDEX event_i1 ON event(mtime); -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
