What is your SQL backend?

On 9/21/12, blambeau <[email protected]> wrote:
> 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.
>
>


-- 
Christian

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
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.

Reply via email to