I have a Lexicon model, and I want user to be able to create dynamic feature to every lexicon. And I have a complicate search interface that let user search on every single feature (including the dynamic ones) belonged to Lexicon model. I could have used a serialized text field to save all the dynamic information if they are not for searching. In case I want to let user search on all fields, I have created a DynamicField Model to hold all dynamically created features. But imagine I have 1,000,000,000 lexicon, and if one create a dynamic feature for every lexicon, this will result creating 1,000,000,000 rows in DynamicField model. So the sql search function will become quite inefficient while a lot of dynamic features created. Is there a better solution for this situation? Which way should I take? searching for a better db design for dynamic fields try to tuning mysql(add cache fields, add index ...) with current db design -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I have a Lexicon model, and I want user to be able to create dynamic feature to every lexicon. And I have a complicate search interface that let user search on every single feature (including the dynamic ones) belonged to Lexicon model. I could have used a serialized text field to save all the dynamic information if they are not for searching. In case I want to let user search on all fields, I have created a DynamicField Model to hold all dynamically created features. But imagine I have 1,000,000,000 lexicon, and if one create a dynamic feature for every lexicon, this will result creating 1,000,000,000 rows in DynamicField model. So the sql search function will become quite inefficient while a lot of dynamic features created. Is there a better solution for this situation? Which way should I take? 1. searching for a better db design for dynamic fields 2. try to tuning mysql(add cache fields, add index ...) with current db design -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
hi, im trying to integrate a "ajax-chat" into my app. within the page where the user post a chatmessage runs a periodically_call_remote to update the message. now, before this happens, the user needs to create a "room" first. now my idea was that the controller could just do a replace_html, which would b a div in the application-layout. but this doesnt work. if im looged in from a different browser, i dont see that update. clearly, im doing something "different here". how would u do that, or any advise? thx -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
boblu wrote:> I have a Lexicon model, and I want user to be able to create dynamic > feature to every lexicon. > > And I have a complicate search interface that let user search on every > single feature (including the dynamic ones) belonged to Lexicon model. > > I could have used a serialized text field to save all the dynamic > information if they are not for searching.You might still want to. Perhaps you can write a routine that writes SQL queries that search through the YAML in the serialized field. It''s annoying, perhaps, but better than the alternative.> > In case I want to let user search on all fields, I have created a > DynamicField Model to hold all dynamically created features. > > But imagine I have 1,000,000,000 lexicon, and if one create a dynamic > feature for every lexicon, this will result creating 1,000,000,000 > rows in DynamicField model. > > So the sql search function will become quite inefficient while a lot > of dynamic features created.That doesn''t follow. You''d have to search through a billion lexicon regardless. Joining another table shouldn''t decrease the efficiency too much, I think> > Is there a better solution for this situation? > > Which way should I take? > > 1. searching for a better db design for dynamic fields > > 2. try to tuning mysql(add cache fields, add index ...) with current > db designYour best bet here is probably 3: use a non-SQL database such as CouchDB or MongoDB. If you do decide to stick with an SQL database, I recommend PostgreSQL -- it will probably deal better with your big tables. Best, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Thank you for the detailed reply. I will have a research on mongoDB. And I am wonderring is there a way to integrate mongoDB with rails? On 5月12日, 午後9:33, Marnen Laibow-Koser <li...@ruby-forum.com> wrote:> boblu wrote: > > I have a Lexicon model, and I want user to be able to create dynamic > > feature to every lexicon. > > > And I have a complicate search interface that let user search on every > > single feature (including the dynamic ones) belonged to Lexicon model. > > > I could have used a serialized text field to save all the dynamic > > information if they are not for searching. > > You might still want to. Perhaps you can write a routine that writes > SQL queries that search through the YAML in the serialized field. It''s > annoying, perhaps, but better than the alternative. > > > > > In case I want to let user search on all fields, I have created a > > DynamicField Model to hold all dynamically created features. > > > But imagine I have 1,000,000,000 lexicon, and if one create a dynamic > > feature for every lexicon, this will result creating 1,000,000,000 > > rows in DynamicField model. > > > So the sql search function will become quite inefficient while a lot > > of dynamic features created. > > That doesn''t follow. You''d have to search through a billion lexicon > regardless. Joining another table shouldn''t decrease the efficiency too > much, I think > > > > > Is there a better solution for this situation? > > > Which way should I take? > > > 1. searching for a better db design for dynamic fields > > > 2. try to tuning mysql(add cache fields, add index ...) with current > > db design > > Your best bet here is probably 3: use a non-SQL database such as CouchDB > or MongoDB. If you do decide to stick with an SQL database, I recommend > PostgreSQL -- it will probably deal better with your big tables. > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > -- > Posted viahttp://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
[Please quote when replying. This is a mailing list, not just a Web forum.] boblu wrote:> Thank you for the detailed reply. > > I will have a research on mongoDB. > And I am wonderring is there a way to integrate mongoDB with rails?Yes. Best, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Tom Tom wrote:> hi, > > im trying to integrate a "ajax-chat" into my app. within the page where > the user post a chatmessage runs a periodically_call_remote to update > the message. > now, before this happens, the user needs to create a "room" first. now > my idea was that the controller could just do a replace_html, which > would b a div in the application-layout. but this doesnt work. if im > looged in from a different browser, i dont see that update. > clearly, im doing something "different here". > how would u do that, or any advise? > > thxStop hijacking other people''s threads! Learn to create a new topic for new questions. Best, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.