Re: RE: Manual Indexing With Buckets

2015-07-28 Thread Anuj Wadehra
Any more thoughts ? Anyone? Thanks Anuj Sent from Yahoo Mail on Android From:Anuj Wadehra anujw_2...@yahoo.co.in Date:Sat, 25 Jul, 2015 at 5:14 pm Subject:Re: RE: Manual Indexing With Buckets We are in product development and batch size depends on the customer base of customer buying our

Re: Manual Indexing With Buckets

2015-07-28 Thread Michael Shuler
On 07/28/2015 07:54 PM, Anuj Wadehra wrote: Any more thoughts ? Anyone? You could help others try to help you by including details, as previously asked: *From*:sean_r_dur...@homedepot.com sean_r_dur...@homedepot.com *Date*:Fri, 24 Jul, 2015 at 5:39 pm It is a bit hard to follow. Perhaps

Re: RE: Manual Indexing With Buckets

2015-07-25 Thread Anuj Wadehra
Date:Fri, 24 Jul, 2015 at 5:39 pm Subject:RE: Manual Indexing With Buckets It is a bit hard to follow. Perhaps you could include your proposed schema (annotated with your size predictions) to spur more discussion. To me, it sounds a bit convoluted. Why is a “batch” so big (up to 100 million rows

Re: Manual Indexing With Buckets

2015-07-24 Thread Anuj Wadehra
Can anyone take this one? Thanks Anuj Sent from Yahoo Mail on Android From:Anuj Wadehra anujw_2...@yahoo.co.in Date:Thu, 23 Jul, 2015 at 10:57 pm Subject:Manual Indexing With Buckets We have a primary table and we need search capability by batchid column. So we are creating a manual index

RE: Manual Indexing With Buckets

2015-07-24 Thread SEAN_R_DURITY
Indexing With Buckets Can anyone take this one? Thanks Anuj Sent from Yahoo Mail on Androidhttps://overview.mail.yahoo.com/mobile/?.src=Android From:Anuj Wadehra anujw_2...@yahoo.co.inmailto:anujw_2...@yahoo.co.in Date:Thu, 23 Jul, 2015 at 10:57 pm Subject:Manual

Manual Indexing With Buckets

2015-07-23 Thread Anuj Wadehra
We have a primary table and we need search capability by batchid column. So we are creating a manual index for search by batch id. We are using buckets to restrict a row size in batch id index table to 50mb. As batch size may vary drastically ( ie one batch id may be associated to 100k row keys