On Wed, Mar 30, 2011 at 3:03 AM, hendra kusuma <[email protected]> wrote: >> Unsurprising as delphi is much faster than ruby, and I'm guessing the >> database library wasn't as abstracted as Sequel is. >> You're right, not nearly as abstracted! I use Delphi as well for heavy lifting. I have found myself building sequel-like supporting structures to make my Delphi life more pleasant, but its nothing anywhere near as flexible as Ruby. However, when I need to push three million rows between SQL Server and MySQL, this is the tool of choice for me, even over open source projects like pentaho that can do a similar job.
> Honestly, I am surprised about how slow ruby is. > Before now I never had a problem with speed using ruby. > 15 seconds for 1,000 records is actually kind of slow. My performance with just straight up Sequel datasets is under a second for 1000 records with a sane number of columns (5 - 20) against both SQL Server 2000 and MySQL for the code block you presented. I have one table that has about 150 columns in it and that one took 2 or 3 seconds for 1000 records. Comparatively, if I select all data from the SQL Server table and push into MySQL table (basic export), it takes about 5 seconds for a ~10 column table and 10 seconds for the monster 150 column table on 2500 records. So you might want to check out how your Ruby was compiled and whether your system is properly optimized for Ruby performance. If you're still on 1.8.x branch of Ruby, how you compile your pthreads on some Linux kernels can have a serious impact on performance of Ruby. Google around for ruby performance and how to improve and you'll find plenty to explore. For what its worth, the above is on Macbook Pro 2.3ghz core 2 duo laptop. Hope this helps, Michael -- http://codeconnoisseur.org -- You received this message because you are subscribed to the Google Groups "sequel-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/sequel-talk?hl=en.
