I am already using a relational database (locally SQLite, deploy to Postgres probably). Haven't heard about MariaDB but it looks like it's just better MySQL and not sure how it solves the issues here.
On 28/11/2011, at 19:32, Stuart Coyle <[email protected]> wrote: > If you don't mind using MariaDB you can use my gem: > https://github.com/stuart/acts_as_oqgraph > > On Mon, Nov 28, 2011 at 6:28 PM, ben wiseley <[email protected]> wrote: > Have you considered Amazon's Map Reduce or moving the data to Redis (no-sql, > in memory, ridiculously fast)? > > -ben > > On Mon, Nov 28, 2011 at 7:10 PM, Dmytrii Nagirniak <[email protected]> wrote: > The graph itself is not massive (5000-10000 objects). But takes 10 seconds to > traverse/update in some cases. > > Probably I can multithread it. Just need to make sure DB is not in an > exclusive lock :) > > Or even offloading it into queue may do the job. > > What do you think about it? > > On Nov 28, 2011 6:53 PM, "Nicholas Faiz" <[email protected]> wrote: > OOC, have you tried doing it with a regular traversal in, say, Ruby code? Did > it take very long? If you can multi-thread the tree structures it might not > be that big a problem? > > If it's a truly massive graph then you'd probably want something other than > SQL (as stated above). > > Cheers, > Nick > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/rails-oceania/-/FqGMliNa4I4J. > 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/rails-oceania?hl=en. > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" 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/rails-oceania?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" 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/rails-oceania?hl=en. > > > > -- > Stuart Coyle > stuart dot coyle at gmail dot com > > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby or Rails Oceania" 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/rails-oceania?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby or Rails Oceania" 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/rails-oceania?hl=en.
