Also one more observation was that if we run multiple iterations of the test, the pool should have been warmed up, but still acquire connection takes a lot of time. May be also some internal issue with the pool implementation
On Mon, Dec 25, 2017 at 8:05 AM, shashank Jain <jain...@gmail.com> wrote: > Thanks a lot Jeremy for the insights. Will look for an upgrade and also > try pre connect option > > On Mon, Dec 25, 2017 at 5:57 AM, Jeremy Evans <jeremyeva...@gmail.com> > wrote: > >> On Saturday, December 23, 2017 at 9:47:22 PM UTC-8, shashank Jain wrote: >>> >>> Reason for the above question was that when we run say 300 threads >>> against a pool size of 500 connections, we see acquire connection taking >>> upto 20 secs sometimes across many threads. >>> >> >> That's a lot of threads for CRuby to handle (JRuby may handle the >> situation better). If the connections need to be created, I could easily >> see that kind of performance issue. Preallocating connections may help, >> but you'll pay a hefty startup penalty in that case. >> >> You could try using the mock adapter instead of whatever adapter you are >> currently using, to see if the performance issue is more related to >> connection setup vs. connection pool internals. You could also try >> comparing the current Sequel version to Sequel 4.49.0 and see how much of a >> difference the connection pool refactoring made. >> >> Thanks, >> Jeremy >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "sequel-talk" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/sequel-talk/5NNUNaHqIMY/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> sequel-talk+unsubscr...@googlegroups.com. >> To post to this group, send email to sequel-talk@googlegroups.com. >> Visit this group at https://groups.google.com/group/sequel-talk. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to sequel-talk+unsubscr...@googlegroups.com. To post to this group, send email to sequel-talk@googlegroups.com. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
