Re: [sqlite] Faster check: > or !=

2017-02-13 Thread James K. Lowden
On Mon, 13 Feb 2017 15:32:00 + jose isaias cabrera wrote: > I have a bunch of records to check, and I am wondering which is a > faster check. I am attaching a network DB as client, > > ATTACH 'h:\bkup\test.db' AS client; If you're concerned about speed or reliability, it would be far, fa

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread Simon Slavin
On 13 Feb 2017, at 9:03pm, jose isaias cabrera wrote: >> 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); No. This does not do the same thing as one ind

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread jose isaias cabrera
On 2017-02-13 18:07, Simon Slavin wrote: On 13 Feb 2017, at 3:32pm, jose isaias cabrera 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 l

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread jose isaias cabrera
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 ? Alread

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread Adam DeVita
@mailinglists.sqlite.org Subject: [sqlite] Faster check: > or != Greetings! I have a bunch of records to check, and I am wondering which is a faster check. I am attaching a network DB as client, ATTACH 'h:\bkup\test.db' AS client; and then do an INSERT based on some logic, and one o

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread Simon Slavin
On 13 Feb 2017, at 3:32pm, jose isaias cabrera 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

[sqlite] Faster check: > or !=

2017-02-13 Thread jose isaias cabrera
Greetings! I have a bunch of records to check, and I am wondering which is a faster check. I am attaching a network DB as client, ATTACH 'h:\bkup\test.db' AS client; and then do an INSERT based on some logic, and one of those login is checking against a variable or an actual DB value. Here