Re: [sqlite] Slow JOIN on two indexed text fields. Why?????

Thank you! That was it. I've been pulling my hair out over this all day. I should have seen it. I've never used STRING in my own tables and I inherited this from someone else and didn't even think twice that the type difference would be the issue. Thanks you again. sorka wrote: > > This

Re: [sqlite] Slow JOIN on two indexed text fields. Why?????

Igor Tandetnik wrote: > sorka wrote: >> This is driving me nuts. I have two tables I'm trying to join >> together on two text fields. >> >> CREATE TABLE tmp_role ( programId INTEGER, >> roleNameINTEGER, >> positionINTEGER, >> isNew

Re: [sqlite] Slow JOIN on two indexed text fields. Why?????

sorka wrote: > This is driving me nuts. I have two tables I'm trying to join > together on two text fields. > > CREATE TABLE tmp_role ( programId INTEGER, > roleNameINTEGER, > positionINTEGER, > isNew BOOL, > personIdINTEGER, > nameSTRING);

[sqlite] Slow JOIN on two indexed text fields. Why?????

This is driving me nuts. I have two tables I'm trying to join together on two text fields. CREATE TABLE tmp_role ( programId INTEGER, roleNameINTEGER, positionINTEGER, isNew BOOL, personIdINTEGER, nameSTRING); This table has up to a few dozen records at