Re: Database importing very slow
Thanks for replying. Yes, taps is the latest version. Initially it wouldn't work because of a known issue with Ruby 1.9.1 but it works fine when I used 1.8.7. The taps version number is 0.3.9. The database has 11 tables all of which were generated according to Rails defaults and as such all have an integer primary key. I also confirmed this through directly querying the database in postgres. My database eventually uploaded overnight taking 8 hours (~0.5 kbps!). After uploading my app didn't work so I suspect it didn't upload properly (although I can't prove this). Perhaps I'll try Heroku support directly. On Jun 25, 4:34 am, Oren Teich o...@heroku.com wrote: Are you running the latest version of taps (sudo gem update taps)? Is the primary key on your table an integer? http://blog.heroku.com/archives/2010/4/21/supporting_big_data_part_1/ On Thu, Jun 24, 2010 at 4:25 AM, Brad oconnor.b...@gmail.com wrote: Oops, I didn't say how slow. So far it's been 2 hours. It looks like it'll be at least another hour. On Jun 24, 9:23 pm, Brad oconnor.b...@gmail.com wrote: I'm trying to upload my development database to my heroku app (via heroku db:push) but finding it very slow. My database is not huge - 11 tables, about 57000 records, 13MB diskspace but is taking hours to upload. I don't even know where to start with investigating this. The connection at my end is fine for any other activities. Surely heroku can't be this slow. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.comheroku%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: Database importing very slow
Oops, I didn't say how slow. So far it's been 2 hours. It looks like it'll be at least another hour. On Jun 24, 9:23 pm, Brad oconnor.b...@gmail.com wrote: I'm trying to upload my development database to my heroku app (via heroku db:push) but finding it very slow. My database is not huge - 11 tables, about 57000 records, 13MB diskspace but is taking hours to upload. I don't even know where to start with investigating this. The connection at my end is fine for any other activities. Surely heroku can't be this slow. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: Database importing very slow
Are you running the latest version of taps (sudo gem update taps)? Is the primary key on your table an integer? http://blog.heroku.com/archives/2010/4/21/supporting_big_data_part_1/ On Thu, Jun 24, 2010 at 4:25 AM, Brad oconnor.b...@gmail.com wrote: Oops, I didn't say how slow. So far it's been 2 hours. It looks like it'll be at least another hour. On Jun 24, 9:23 pm, Brad oconnor.b...@gmail.com wrote: I'm trying to upload my development database to my heroku app (via heroku db:push) but finding it very slow. My database is not huge - 11 tables, about 57000 records, 13MB diskspace but is taking hours to upload. I don't even know where to start with investigating this. The connection at my end is fine for any other activities. Surely heroku can't be this slow. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.comheroku%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups Heroku group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.