On 2017-02-13 18:07, Simon Slavin wrote:
On 13 Feb 2017, at 3:32pm, jose isaias cabrera <[email protected]>
wrote:
Any input would be greatly appreciated.
I doubt there's much difference, though the one with the fixed
timestamp string may be a touch faster.
But the real speedup would come from an index like this:
CREATE INDEX client.OP_IPX ON client.OpenProjects (id,ProjID,XtraB)
Simon.
Yes. Already done that.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users