> 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 is stored in unix timestamp, so it's just about comparing integers. But maybe I'm wrong. > >> 2- What can I do to optimize the all process ? (play with some PRAGMA >> parameters maybe) > > pragma page_size=4096; > pragma default_cache_size=200000; > pragma cache_size=200000; > > (cache with this options is 200 000 * 4k=800 Mb). > >> 3- Is sqlite a good choice for this case ? Would mysql or postgresql a >> better choice ? > > SQLite is good choice but data flow parser is more better then sql queries for > realtime analyze. You can write demon for prepare data to load in database and > inserting data periodically with transactions. i'm not planning to do real time analysis. I want to do some stats after (several days or month) to study the users behaviours on the website. > > Best regards. Thx a lot _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users