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

Reply via email to