Hi there,
I would like to know some ideas from different people upon this performance
issue I am going through.
I contribute to a gem named impressionist<https://github.com/charlotte-ruby/impressionist/issues/94>,
It basically saves an 'impression' of a end user.
Everything works fine, I'm refactoring the code right now so if you
checkout the gem, don't be scared.
An user has posted a Performance Issue on github whereas he has 220.000
rows on their db(pg) and impressionist is working very slow.
The reason is, In a app controller one can specify how impressions are
going to be saved, so one could choose to only log unique impressions.
Fair enough, However impressionist has to look through all the records in
the db in order to save an unique impression using the following query:

(13684.8ms) SELECT DISTINCT COUNT(DISTINCT "impressions"."request_hash")
FROM "impressions" WHERE "impressions"."impressionable_id" = $1 AND
"impressions"."impressionable_type" = $2 [["impressionable_id", 60],
["impressionable_type", "Artist"]]

As you can see it goes through the db searching for a distinct request_hash
on that particular record saved.
That's where it all started, It basically takes 13 seconds to do this task
and then does something else, Obviously it is not suitable for production
mode.
The solution I've got in mind is:


    -

    Use Ruby Threads(ThreadsWait standard ruby lib, written by Keiju
    ISHITSUKA) and Mutex to prevent deadlocks
    -

    Also use Memcache

Problems are:


    -

    Using cache I'd have to tell impressionist to do a in memory
    search(cached results) and upon that it may or may not save an impression.
    -

    I don't know if this is viable, because Impressionist would have to go
    through all the cached records and to see if there wasn't any record saved.

Thanks ever so much

Have fun, ABC( *Always Be Coding*)

--
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 rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/4fbeea19-aff1-40ad-8939-e217aa259835%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedJul 11, '13 at 4:37p
activeJul 11, '13 at 4:37p
posts1
users1
websiterubyonrails.org
irc#RubyOnRails

1 user in discussion

Nalesso Moreira: 1 post

People

Translate

site design / logo © 2022 Grokbase