subject:"\[sqlite\] SQL Optimisation"

Re: [sqlite] SQL Optimisation

2017-02-04 Thread Simon Slavin

On 4 Feb 2017, at 3:31pm, Nigel Verity wrote: > My question regards the SQL I've used to populate the grid. I'm no SQL guru, > so joining all the tables together in a single view using multiple nested > left joins is probably beyond my comfort level. You don’t have

[sqlite] SQL Optimisation

2017-02-04 Thread Nigel Verity

Hi I have a database which describes the various phases of a product lifecycle - one table per phase, one row per product. This is accessed by an application (developed in Gambas3) which displays the entire lifecycle of each product in a grid - left to right. Each phase also has its own