Re: [sqlite] Help forming query

2014-06-18 Thread Bradley Giesbrecht
gt;>> 1 >>> 1 >>> 1 >>> 4 >>> _ >>> _ >>> 4 >>> _ >> >> note that "_" means "no data". i want to get a list with [1, 4] as the >> result. what is the proper SQLite query for this? You w

Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread Bradley Giesbrecht
> produce approximately 4.4 billion rows and then uses a GROUP BY and COUNT > to return some values to me. If your data is somewhat static use aggregate tables which can updated on data change. Regards, Bradley Giesbrecht (pixilla) ___ sqlite-use

Re: [sqlite] Beginning database question

2013-05-14 Thread Bradley Giesbrecht
nager/ Regards, Bradley Giesbrecht (pixilla) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users