Hi, I have a basic question about how to setup my models and DB structure.
I will have an app that allow users to upload pictures. Pictures are related to cities. Users can upload pictures for many cities. The visitors can view the pictures based on the city they are visiting. So when they do a search obviously the search scope on the DB should be at city level. I might end up with many many records and my questions are targeting DB efficiency. 1- Should I have a Pictures table that has a City column on it? 2- Should I have a City table that has a Pictures column on it? What users will search and view are pictures not cities so I'm not sure what will be best if amount of records would be high. I guess it would be good to use some indexing on Cities also (?)... As you can see I'm not experienced with DB, any suggestions will be appreciated. Cheers. -- 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
