Thanks Christian, I've made additional tests... It seems that, unlike `schema`, results of `table_exists?` and `indexes` are not cached at all?
Do you know whether this is on intent? Thanks, B On Friday, September 21, 2012 4:29:03 PM UTC+2, Christian MICHON wrote: > > On Fri, Sep 21, 2012 at 4:04 PM, blambeau <[email protected] <javascript:>> > wrote: > > > > Hi guys, > > > > I'm facing a little issue with Sequel in a Sinatra application (ran with > thin). > > > > My logs show that a new database connection seems created and > catalog-related queries sent for every request (so, no schema cache at > all). I've checked that the same ::Sequel::Database instance is used for > every request. > > > > When I do something similar in irb, everything seems fine and > catalog-related queries are sent only once. > > > > I've played with different connection pooling options, without success > so far... > > > > Does anyone know why those behaviors are observed? Otherwise, I'll try > to reproduce on a simple example. > > > > Thanks! > > Bernard > > Did you use a constant like DB for Sequel connection? > > How does the log look like? How did you figure out new connections were > made? > > I use sequel+sinatra with trinidad (tomcat in jruby) and did not > notice this. Maybe I need to have a deeper look at my logs, but I'm > pretty sure no extra database connection happen. > > I can help out if you send a simple example. > > -- > Christian > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/-TNfpO0oA7sJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
