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
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
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
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
@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
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
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
7 matches
Mail list logo