Hi, I''ve just upgraded to 0.13, and now my site is noticeably slower. I didn''t make any other changes during the upgrade. I did ensure that .htaccess dispatch.cgi was changed to .fcgi also. Has anyone experienced this similar results, or did I somehow manage to mess something up? Thanks
On Jul 7, 2005, at 9:07 AM, James Earl wrote:> Hi, > > I''ve just upgraded to 0.13, and now my site is noticeably slower. I > didn''t make any other changes during the upgrade. I did ensure that > .htaccess dispatch.cgi was changed to .fcgi also. > > Has anyone experienced this similar results, or did I somehow manage > to mess something up? >If it is only slower in development mode, this changeset might have already fixed the problem: http://dev.rubyonrails.com/changeset/1752 - Jamis
You did delete your other dispatch files after you upgraded yor app right? On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 9:07 AM, James Earl wrote: > > > Hi, > > > > I''ve just upgraded to 0.13, and now my site is noticeably slower. I > > didn''t make any other changes during the upgrade. I did ensure that > > .htaccess dispatch.cgi was changed to .fcgi also. > > > > Has anyone experienced this similar results, or did I somehow manage > > to mess something up? > > > > If it is only slower in development mode, this changeset might have > already fixed the problem: > > http://dev.rubyonrails.com/changeset/1752 > > - Jamis > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Ron Sweeney wrote:> You did delete your other dispatch files after you upgraded yor app right?I''m just in development using webrick and I notice that 0.13 is much slower compared to before. What "other dispatch files" are you talking about?> > On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote: > >>On Jul 7, 2005, at 9:07 AM, James Earl wrote: >> >> >>>Hi, >>> >>>I''ve just upgraded to 0.13, and now my site is noticeably slower. I >>>didn''t make any other changes during the upgrade. I did ensure that >>>.htaccess dispatch.cgi was changed to .fcgi also. >>> >>>Has anyone experienced this similar results, or did I somehow manage >>>to mess something up? >>> >> >>If it is only slower in development mode, this changeset might have >>already fixed the problem: >> >> http://dev.rubyonrails.com/changeset/1752 >> >>- Jamis >> >>_______________________________________________ >>Rails mailing list >>Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >>http://lists.rubyonrails.org/mailman/listinfo/rails >> > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails
Yes. My first encounter with 0.13 slowness was setting up a new web server at another company. After setting it up I couldn''t figure out why it was going so slow, and thought I would have to tell them their system was too slow to run Rails. I''ve since downgraded them to 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE system with Apache 1.3.31. On 7/7/05, Ron Sweeney <ron.sweeney-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> You did delete your other dispatch files after you upgraded yor app right? > > On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote: > > On Jul 7, 2005, at 9:07 AM, James Earl wrote: > > > > > Hi, > > > > > > I''ve just upgraded to 0.13, and now my site is noticeably slower. I > > > didn''t make any other changes during the upgrade. I did ensure that > > > .htaccess dispatch.cgi was changed to .fcgi also. > > > > > > Has anyone experienced this similar results, or did I somehow manage > > > to mess something up? > > > > > > > If it is only slower in development mode, this changeset might have > > already fixed the problem: > > > > http://dev.rubyonrails.com/changeset/1752 > > > > - Jamis > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
On Jul 7, 2005, at 12:11 PM, James Earl wrote:> Yes. My first encounter with 0.13 slowness was setting up a new web > server at another company. After setting it up I couldn''t figure out > why it was going so slow, and thought I would have to tell them their > system was too slow to run Rails. I''ve since downgraded them to > 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE > system with Apache 1.3.31.What database are you using? MySQL? If so, be _very_, _very_ certain that you are using the _native_ drivers, and NOT the pure Ruby ones. - Jamis
Jamis, For those of us who aren''t in this situation, but would like to steer clear in the future, how can we tell if we''re using the native drivers or the Ruby ones? On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 12:11 PM, James Earl wrote: > > > Yes. My first encounter with 0.13 slowness was setting up a new web > > server at another company. After setting it up I couldn''t figure out > > why it was going so slow, and thought I would have to tell them their > > system was too slow to run Rails. I''ve since downgraded them to > > 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE > > system with Apache 1.3.31. > > What database are you using? MySQL? > > If so, be _very_, _very_ certain that you are using the _native_ > drivers, and NOT the pure Ruby ones. > > - Jamis > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- - Frank FrankManno.com <a href="http://www.spreadfirefox.com/?q=affiliates&id=2496&t=1">Get Firefox!</a>
On Jul 7, 2005, at 12:29 PM, Frank Manno wrote:> Jamis, > > For those of us who aren''t in this situation, but would like to steer > clear in the future, how can we tell if we''re using the native drivers > or the Ruby ones?Have a read here: http://blog.x180.net/2005/07/rails_and_mysql.html Very enlightening, overall. - Jamis
any care to inform me as to how you can tell if you are using the native postgresql driver? _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 12:11 PM, James Earl wrote: > > > Yes. My first encounter with 0.13 slowness was setting up a new web > > server at another company. After setting it up I couldn''t figure out > > why it was going so slow, and thought I would have to tell them their > > system was too slow to run Rails. I''ve since downgraded them to > > 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE > > system with Apache 1.3.31. > > What database are you using? MySQL? > > If so, be _very_, _very_ certain that you are using the _native_ > drivers, and NOT the pure Ruby ones.While this advice is certainly good, I don''t think it applies to the OP''s question of "0.12 = fast, 0.13 = slow"... or was there some change in 0.13 that causes rails to use the pure ruby driver where 0.12 did not?
On Jul 7, 2005, at 11:50 AM, Sean T Allen wrote:> any care to inform me as to how you can tell if you are using the > native postgresql driver?''gem install postgres'' gets you the native drivers. ''gem install postgres-pr'' gets you the pure-ruby drivers. Definitely go for the former unless you don''t have access to a compiler for the C extension. jeremy
On Jul 7, 2005, at 12:09 PM, Jeremy Kemper wrote:> On Jul 7, 2005, at 11:50 AM, Sean T Allen wrote: >> any care to inform me as to how you can tell if you are using the >> native postgresql driver? > > ''gem install postgres'' gets you the native drivers. > ''gem install postgres-pr'' gets you the pure-ruby drivers. > > Definitely go for the former unless you don''t have access to a > compiler for the C extension.Sorry, you asked how to tell whether you''re running native: $ irb -rubygems > PGconn NameError: uninitialized constant PGconn $ irb -rubygems > require ''postgres.so'' > PGconn PGconn jeremy
Jeremy Kemper wrote:> On Jul 7, 2005, at 11:50 AM, Sean T Allen wrote: > >> any care to inform me as to how you can tell if you are using the >> native postgresql driver? > > > ''gem install postgres'' gets you the native drivers. > ''gem install postgres-pr'' gets you the pure-ruby drivers. > > Definitely go for the former unless you don''t have access to a > compiler for the C extension. >And is there a way to check to see which you are actually using? _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 12:11 PM, James Earl wrote: > > > Yes. My first encounter with 0.13 slowness was setting up a new web > > server at another company. After setting it up I couldn''t figure out > > why it was going so slow, and thought I would have to tell them their > > system was too slow to run Rails. I''ve since downgraded them to > > 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE > > system with Apache 1.3.31. > > What database are you using? MySQL? > > If so, be _very_, _very_ certain that you are using the _native_ > drivers, and NOT the pure Ruby ones.Yes, MySQL. What does Rails ship with? That''s what I''m using.
On Jul 7, 2005, at 1:22 PM, James Earl wrote:> On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote: > >> On Jul 7, 2005, at 12:11 PM, James Earl wrote: >> >> >>> Yes. My first encounter with 0.13 slowness was setting up a new web >>> server at another company. After setting it up I couldn''t figure >>> out >>> why it was going so slow, and thought I would have to tell them >>> their >>> system was too slow to run Rails. I''ve since downgraded them to >>> 0.12.1 and everything is speedy now. This is a FreeBSD 5.4-RELEASE >>> system with Apache 1.3.31. >>> >> >> What database are you using? MySQL? >> >> If so, be _very_, _very_ certain that you are using the _native_ >> drivers, and NOT the pure Ruby ones. >> > > Yes, MySQL. What does Rails ship with? That''s what I''m using.I''m not sure why, but it appears as though the pure ruby mysql adapter is much slower with 0.13 than it was before. If you use the native driver, things will be much snappier. (You can install the native driver via gems, "gem install mysql".) In general, the native driver is better to use, regardless. - Jamis
> > Sorry, you asked how to tell whether you''re running native: > > $ irb -rubygems > > PGconn > NameError: uninitialized constant PGconn > > $ irb -rubygems > > require ''postgres.so'' > > PGconn > PGconn >irb -rubygems gives an unrecognized switch error _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 1:22 PM, James Earl wrote: > > Yes, MySQL. What does Rails ship with? That''s what I''m using. > > I''m not sure why, but it appears as though the pure ruby mysql > adapter is much slower with 0.13 than it was before. If you use the > native driver, things will be much snappier. (You can install the > native driver via gems, "gem install mysql".) > > In general, the native driver is better to use, regardless.Excellent, I''ll give this a try! Thanks
For those of us behind proxies where can we download the gem from? I have been googling and I can''t seem to find it... - Michael On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote:> On Jul 7, 2005, at 1:22 PM, James Earl wrote: > > I''m not sure why, but it appears as though the pure ruby mysql > adapter is much slower with 0.13 than it was before. If you use the > native driver, things will be much snappier. (You can install the > native driver via gems, "gem install mysql".) > > In general, the native driver is better to use, regardless. > > - Jamis > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
http://gems.rubyforge.org On 7/7/05, Michael King <kingmt-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> For those of us behind proxies where can we download the gem from? I > have been googling and I can''t seem to find it... > > - Michael > > On 7/7/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> wrote: > > On Jul 7, 2005, at 1:22 PM, James Earl wrote: > > > > I''m not sure why, but it appears as though the pure ruby mysql > > adapter is much slower with 0.13 than it was before. If you use the > > native driver, things will be much snappier. (You can install the > > native driver via gems, "gem install mysql".) > > > > In general, the native driver is better to use, regardless. > > > > - Jamis > > > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Jamis Buck wrote:> I''m not sure why, but it appears as though the pure ruby mysql adapter > is much slower with 0.13 than it was before. If you use the native > driver, things will be much snappier. (You can install the native > driver via gems, "gem install mysql".) > > In general, the native driver is better to use, regardless.Can anyone advise on what I need to install the native driver on Windows? TIA Justin
On 7/7/05, Justin Forder <justin-zSfPWr5aQuznITO/+xaoB7VCufUGDwFn@public.gmane.org> wrote:> Jamis Buck wrote: > > > I''m not sure why, but it appears as though the pure ruby mysql adapter > > is much slower with 0.13 than it was before. If you use the native > > driver, things will be much snappier. (You can install the native > > driver via gems, "gem install mysql".) > > > > In general, the native driver is better to use, regardless. > > Can anyone advise on what I need to install the native driver on Windows? > > TIA > > JustinYou will need the MySQL C API which you won''t have gotten if you downloaded and installed MySQL''s Windows "Essentials" package like I did. Go to MySQL.com and download the non-installer version and you will be able to copy over the necessary lib and include folders. Despite this, I am still having problems installing the gem on Windows and it doesn''t report any specific errors. It just lists the extconf.rb line in the gem_make.out file. Any help anyone can provide would be appreciated! -- Chris Griego
There is a performance problem in .13.0 in dev mode caused by the patch to reduce the memory leak. This has been corrected in the trunk and the latest beta gems, so grab those as well as using the proper mysql driver. Cheers, Chris -- snip --
Chris Griego wrote:> On 7/7/05, Justin Forder <justin-zSfPWr5aQuznITO/+xaoB7VCufUGDwFn@public.gmane.org> wrote: > >>Jamis Buck wrote: >> >> >>>I''m not sure why, but it appears as though the pure ruby mysql adapter >>>is much slower with 0.13 than it was before. If you use the native >>>driver, things will be much snappier. (You can install the native >>>driver via gems, "gem install mysql".) >>> >>>In general, the native driver is better to use, regardless. >> >>Can anyone advise on what I need to install the native driver on Windows? >> >>TIA >> >> Justin > > > You will need the MySQL C API which you won''t have gotten if you > downloaded and installed MySQL''s Windows "Essentials" package like I > did. Go to MySQL.com and download the non-installer version and you > will be able to copy over the necessary lib and include folders. > Despite this, I am still having problems installing the gem on Windows > and it doesn''t report any specific errors. It just lists the > extconf.rb line in the gem_make.out file. Any help anyone can provide > would be appreciated! >Thanks - I''ll hold off until I have better information. Justin
Chris Griego wrote:> On 7/7/05, Justin Forder <justin-zSfPWr5aQuznITO/+xaoB7VCufUGDwFn@public.gmane.org> wrote: >>Can anyone advise on what I need to install the native driver on Windows? >> >>TIA >> >> Justin > > > You will need the MySQL C API which you won''t have gotten if you > downloaded and installed MySQL''s Windows "Essentials" package like I > did. Go to MySQL.com and download the non-installer version and you > will be able to copy over the necessary lib and include folders. > Despite this, I am still having problems installing the gem on Windows > and it doesn''t report any specific errors. It just lists the > extconf.rb line in the gem_make.out file. Any help anyone can provide > would be appreciated! >The full installer version (http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip/from/pick) includes options to install the header files and such. I''ve got the mysql extension to work before (not the gem) by tweaking the extconf.rb file and specifying the "--with-*" options - see http://www.bantamtech.com/~kevin/?p=28. Cheers, Kevin
On 7/7/05, Chris McGrath <c.r.mcgrath-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> There is a performance problem in .13.0 in dev mode caused by the > patch to reduce the memory leak. This has been corrected in the trunk > and the latest beta gems, so grab those as well as using the proper > mysql driver.Or, do what I do and skip the 0.13.0 upgrade, wait for 0.13.1 ;) -- Urban Artography http://artography.ath.cx