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" *Date*:Fri, 24 Jul, 2015 at 5:39 pm It is a bit hard to follow. Perhaps you could include your prop

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" 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 pro

Re: RE: Manual Indexing With Buckets

2015-07-25 Thread Anuj Wadehra
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)? Is a row in t

RE: Manual Indexing With Buckets

2015-07-24 Thread SEAN_R_DURITY
ject: Re: Manual Indexing With Buckets Can anyone take this one? Thanks Anuj Sent from Yahoo Mail on Android<https://overview.mail.yahoo.com/mobile/?.src=Android> From:"Anuj Wadehra" mailto:anujw_2...@yahoo.co.in>> Date:Thu, 23 Jul, 2015 at

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" 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 for search by batch id

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