Re: [sqlite] Any change to make this query better?

Thanks, Eduardo. Obrigado, or gracias. :-) Adding an INDEX for (ProjID, PSubClass, lower(cust)) has dropped both queries to less than 2 seconds: BEFORE INDEX: Run Time: real 125.947 user 0.795605 sys 4.648830 Run Time: real 130.343 user 1.622410 sys 7.035645 AFTER INDEX: Run Time: real 1.38

Re: [sqlite] How to create primary key from two another PK's?

Hi, On Oct 21, 2017 5:18 AM, "csanyipal" wrote: I try to follow advices and modify my database so it is now like this: *CREATE TABLE "student" ( "idnum" TEXT NOT NULL CONSTRAINT "pk_student" PRIMARY KEY, "studentname" TEXT NOT NULL, "teachinglang" VARCHAR(2) NOT NULL, "grade" TINYINT,

Re: [sqlite] Any change to make this query better?

On Fri, 20 Oct 2017 14:21:38 -0400 "jose isaias cabrera" wrote: > > Greetings! > > This takes about 1.5 minutes to run with sqlite v3.20.1 with about > 200K records > > sqlite> explain query plan >...> SELECT >...> O.XtraF AS PortalID, >...> O.ProjID, >...> O.A_No AS GTXN

Re: [sqlite] How to create primary key from two another PK's?

I try to follow advices and modify my database so it is now like this: *CREATE TABLE "student" ( "idnum" TEXT NOT NULL CONSTRAINT "pk_student" PRIMARY KEY, "studentname" TEXT NOT NULL, "teachinglang" VARCHAR(2) NOT NULL, "grade" TINYINT, "classname" VARCHAR(1) NOT NULL, "formmaster" TEX