Re: [sqlite] Sqlite optim

2009-02-24 Thread Jérôme Loyet
> On Monday 23 February 2009 13:09:58 Jérôme Loyet wrote: >> My questions: >> 1- Is there a better way to populate the `siblings` table ? (optimize >> my sql request) > > You may use compose index on (cookie,referer,date) and REAL datatype for > dates. I choosed integer for the date as everything

Re: [sqlite] Sqlite optim

2009-02-23 Thread Alexey Pechnikov
Hello! On Monday 23 February 2009 13:09:58 Jérôme Loyet wrote: > My questions: > 1- Is there a better way to populate the `siblings` table ? (optimize > my sql request) You may use compose index on (cookie,referer,date) and REAL datatype for dates. > 2- What can I do to optimize the all proces

[sqlite] Sqlite optim

2009-02-23 Thread Jérôme Loyet
Hello everyone, I'm doing some web logs analysis. I decided to use a sqlite database because the application has to be easily portable to another workstation or server and there is absolutly no need of multi-clients. Moreover, I don't want to spend my time dealing with the database. What I want t