I have 2 SQLite3 tables like this

table persons (~15,000 records)
ID, Name, Address
ID is PK

table OtherInfo (~10,000 records)
ID, personID, InfoNumber
ID is PK, personID is FK and UNIQUE

Even though there is just one InfoNumber for each person, it wasnt created in the person table inorder to save space (in the actual table, there are many more VARCHAR fields).

But now, the LEFT JOIN query is taking a whole lot of time, so I may have to restructure the tables to have all fields in a single table.

But is there a way out for the LEFT JOIN query ?

Thanks

what does "a way out" mean?

did you declare an index on personID?

I initially create index on 2 columns :

CREATE UNIQUE INDEX IF NOT EXISTS "UID" ON "OtherInfo" (personID, InfoNumber);

But have changed that to personID UNIQUE only. Now not so slow.

But as more data is added, LEFT JOIN query is going to be slower. I was wondering if there was to optmize it instead of restructuring the table altogether.

You have an ID column on OtherInfo. Is that necessary? Why not make PersonID the key since you know it will be unique?