I've just pushed a few performance enhancing commits. The commits for model initialization and hooks should significantly speed up model instance creation for all databases. If you are using PostgreSQL, you definitely want to try the master branch, as that commit had about a 3x performance enhancement. There have been some other bugfix commits as well.
With the latest master branch, I'm getting faster than ActiveRecord performance on PostgreSQL for model code that doesn't involve dates. For code that includes dates, ActiveRecord is three times faster than Sequel to give you model objects, until you ask for the attributes, after which it is Sequel is twice as fast as ActiveRecord . This is because ActiveRecord doesn't typecast the strings given by PostgreSQL until you access them, and creating a ruby Date instance is very slow. This can lead to some performance decrease if you are converting an app from ActiveRecord to Sequel and have to deal with dates. However, code that is slower with Sequel is probably due to the fact that you are selecting a date attribute and not using it (if you were using it, ActiveRecord would have to typecast and Sequel would be faster). If that is the case, just use Dataset#select to only select the columns you need, and you'll get a significant speed up. Jeremy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
