On 2017-02-13 17:20, Adam DeVita wrote:
How much control do you have?
All of it.
Can you put out your date code into an integer field?
Hmmm... I could. I have to do some programming to replace the normal
date with the integer date.
Can you set an index on id, projId, and Xtrab ?
Already have one for each.
CREATE INDEX OpPid ON LSOpenProjects (ProjID);
CREATE INDEX XtraBLSOpenProjects ON LSOpenProjects (XtraB);
CREATE TABLE LSOpenProjects
(
id integer primary key, ProjID integer,...
);
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
