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 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. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
