Re: Unique users analysis

2011-09-07 Thread Radek Maciaszek
ery is running only on users that have an id that ends with 00. >> >> At the end we multiply by 256 and get a pretty close number to the real >> number. >> >> >> >> Itai >> >> >> >> On 01/14/2011 01:14 PM, Radek Maciaszek wrote: >>

Re: Unique users analysis

2011-01-14 Thread Radek Maciaszek
s with 00. > > At the end we multiply by 256 and get a pretty close number to the real > number. > > > > Itai > > > > On 01/14/2011 01:14 PM, Radek Maciaszek wrote: > > Hi, >> >> I am working on some large scale unique users analysis (think hund

Re: Unique users analysis

2011-01-14 Thread Itai Hochman
number to the real number. Itai On 01/14/2011 01:14 PM, Radek Maciaszek wrote: Hi, I am working on some large scale unique users analysis (think hundreds of millions of records per day). Since number of all records per month goes into many billions I am hoping that there may be some

Unique users analysis

2011-01-14 Thread Radek Maciaszek
Hi, I am working on some large scale unique users analysis (think hundreds of millions of records per day). Since number of all records per month goes into many billions I am hoping that there may be some alternative to running "SELECT DISTINCT user_unique_id..." such as sampling data