Re: Fastes way to import 100m rows

2014-05-19 Thread Andreas Hembach
n-Hershko > http://code972.com | @synhershko <https://twitter.com/synhershko> > Freelance Developer & Consultant > Author of RavenDB in Action <http://manning.com/synhershko/> > > > On Mon, May 19, 2014 at 7:35 PM, Andreas Hembach > > > wrote: > >&

Re: Fastes way to import 100m rows

2014-05-19 Thread Andreas Hembach
emote connection? > > -- > > Itamar Syn-Hershko > http://code972.com | @synhershko <https://twitter.com/synhershko> > Freelance Developer & Consultant > Author of RavenDB in Action <http://manning.com/synhershko/> > > > On Mon, May 19, 2014 at 7:16 P

Fastes way to import 100m rows

2014-05-19 Thread Andreas Hembach
Hi all, i need to import 100m rows. At the moment i use the bulk api with 100 entries at once (Is that a good or a bad value?). But i only get ~500 rows/second imported (Is that a lot or a little more?). Is there a way to import the data faster? I set number_of_replicas = 0 and refresh_interval

need help with aggregation and unique counted values

2014-03-18 Thread Andreas Hembach
Hi all, i'm new here and have a problem with an query. I hope someone can help me. My Problem: - I have a log with user clicks, the user revenue and there session id's. Now i want to build a data histogram with all counted clicks, the unqiue session ids and the user revenue. My Query: { "qu