Joe Peck
2010-Mar-16 20:30 UTC
Writing a large file with Spreadsheet: very slow, any HELP?
Hey, I''m using the Spreadsheet gem to generate Excel files. It''s worked great up until now. I''m trying to put 25,000 rows in a sheet, then doing book.write to write the file. It''s really slow, like 3-4 minutes. Is there a way to write groups of rows to a sheet at a time, or some other way to speed up this process? Thanks in advance for any advice. -- 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.
Joe Peck
2010-Mar-17 12:54 UTC
Re: Writing a large file with Spreadsheet: very slow, any HELP?
Joe Peck wrote:> Hey, > > I''m using the Spreadsheet gem to generate Excel files. It''s worked > great up until now. > > I''m trying to put 25,000 rows in a sheet, then doing book.write to write > the file. It''s really slow, like 3-4 minutes. > > Is there a way to write groups of rows to a sheet at a time, or some > other way to speed up this process? Thanks in advance for any advice.Oh yeah, I''m using the latest Spreadsheet gem, 0.6.4.1 if that makes a difference. Any thoughts on how to speed up the writing process? -- 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.
David Chua
2010-Mar-17 15:31 UTC
Re: Re: Writing a large file with Spreadsheet: very slow, any HELP?
I hope you''re sending those tasks to a background worker... On Wed, Mar 17, 2010 at 8:54 PM, Joe Peck <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Joe Peck wrote: > > Hey, > > > > I''m using the Spreadsheet gem to generate Excel files. It''s worked > > great up until now. > > > > I''m trying to put 25,000 rows in a sheet, then doing book.write to write > > the file. It''s really slow, like 3-4 minutes. > > > > Is there a way to write groups of rows to a sheet at a time, or some > > other way to speed up this process? Thanks in advance for any advice. > > Oh yeah, I''m using the latest Spreadsheet gem, 0.6.4.1 if that makes a > difference. Any thoughts on how to speed up the writing process? > -- > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Joe Peck
2010-Mar-17 15:35 UTC
Re: Re: Writing a large file with Spreadsheet: very slow, any HELP?
David Chua wrote:> I hope you''re sending those tasks to a background worker...Not yet, but that''s probably the route I''ll be going. -- 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.