Thanks for the swift reply! So the application will utilize two databases, one just for the zipcodes table? How would I go about that? Know of any decent references for something like this?
On Nov 13, 1:50 pm, Darian Shimy <[email protected]> wrote: > I would create a new database, load that table in the new database, and > create a view from your database used by rails to the new db you created. > That way you will only be recreating the view and not the whole table. > > If you are dealing with indexes on the table, be sure to add the indexes > before you load the data. Faster. > -- > Darian Shimy > > http://www.darianshimy.comhttp://twitter.com/dshimy > > > > On Fri, Nov 13, 2009 at 1:40 PM, jrgoodner <[email protected]> wrote: > > > Hey there, I'm not super familiar with MySQL, so please forgive me if > > I say something stupid. > > > I have a large database table (it includes every zipcode in the U.S., > > along with its city,state,latitude,longitude), and it seems that we > > are frequently dropping/creating/migrating our database. It takes a > > very long time to migrate the zipcodes table (I do so from a .csv, > > creating a Zipcode object row by row). > > > I'd like to dump the table with MySQLdump. Then, when migrating, > > rather than run the ruby code that creates a bunch of objects, instead > > load the resulting dump file. [With the hopes that that will be a > > quicker process...think that's the case?] > > > I don't know how to load the dump file using Rails migrations, and I'd > > like to. Any thoughts? Re: any part of this process? Is this a > > silly thing to do? How would you guys suggest I go about migrating > > tables w/large amounts of data? > > > Thanks in advance, any advice is MUCH APPRECIATED!! > > > --Jared > > -- > Darian Shimy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
