Re: [sqlite] Newbie sql: query and joining more than two tables

Thanks for your suggestions! On Monday 06 June 2005 05.22, Ulrik Petersen wrote: > Hi Karim, > > Cláudio Leopoldino wrote: > > You may use EXPLAIN clause and verify the reazon... > > > > Cláudio > > > >> Hi! > >> > >> I hope to get some feedback whether the query time is what I should > >>

Re: [sqlite] Newbie sql: query and joining more than two tables

Hi Karim, Cláudio Leopoldino wrote: You may use EXPLAIN clause and verify the reazon... Cláudio Hi! I hope to get some feedback whether the query time is what I should expect. Running this query below takes several seconds - typically 1-3s. SELECT package.id, package.name,

Re: [sqlite] Newbie sql: query and joining more than two tables

You may use EXPLAIN clause and verify the reazon... Cláudio Hi! I hope to get some feedback whether the query time is what I should expect. Running this query below takes several seconds - typically 1-3s. SELECT package.id, package.name, package.description, package.size,

[sqlite] Newbie sql: query and joining more than two tables

Hi! I hope to get some feedback whether the query time is what I should expect. Running this query below takes several seconds - typically 1-3s. SELECT package.id, package.name, package.description, package.size, package.latest, version.version FROMcategory, package,