Hello Hans! In order for anyone to help you (who might not be experienced with sorcery), a lot more information is needed. But perhaps just some debugging hints would be helpful:
Could you write the output from the SQL (and a explain analyze of this query) that is triggered with the update. Are there any callbacks (or database-level triggers, index updates) doing stuff in an update, or is it only the sql that takes time? An update to a table of 6000 rows should not take close to that time to just update a date. But there might be other stuff happening when you do this. Albert On Fri, Sep 25, 2015 at 2:27 PM, Hans <[email protected]> wrote: > I am now refactoring and optimizing my code and noticed that the calls to > update last_activity_at varies between 50 and 100 ms. > I think is is too much to be ok för a simple update. > > Have others different or the same experience of sorcery ? > > My user table has 6000 rows and 36 fields. (too many - should be > refactored anyhow). > > Can the slow response times depend on this table, sorcery, the server or > the rest of application > > What is wrong ? > > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/1e57391f-fe96-47ec-ae56-ab918ae75a1f%40googlegroups.com > <https://groups.google.com/d/msgid/rubyonrails-talk/1e57391f-fe96-47ec-ae56-ab918ae75a1f%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CA%2B-nmy5%3DnLsiWadQZU2CGpyeaxs8Oi6uUg-6LKXn7ZEKoU62zA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
