Topic: Testing large database, best server option?

Hello,
I'm new to rails and I have been working on a smaller database for testing. Now I'd like to use a database with around 250 users and another table with 50,000 rows or data.
What would be the best server for me to set up at this point? I have found WEBrick cannot handle the amount of data.

Thanks smile

Re: Testing large database, best server option?

Apache2 with FastCGI.

Re: Testing large database, best server option?

thank you.
I've installed Apache 2 straight from the site and I've used RubyForApache to installed just fastcgi.

I've followed http://rawlinson.us/blog/?page_id=309#installingApache and added the following to the httpd.conf file.

LoadModule rewrite_module modules/mod_rewrite.so
LoadModule fastcgi_module modules/mod_fastcgi.so
LoadModule ruby_module modules/mod_ruby.so

<IfModule mod_fastcgi.c>
       AddHandler fastcgi-script .fcgi
     </IfModule>

     <IfModule mod_ruby.c>
       # for Apache::RubyRun
       RubyRequire apache/ruby-run

       # exec files under /ruby as Ruby scripts.
       <Location /ruby>
         SetHandler ruby-object
         RubyHandler Apache::RubyRun.instance
         Options +ExecCGI
       </Location>

       # exec *.rbx as Ruby scripts.
       <Files *.rbx>
         SetHandler ruby-object
         RubyHandler Apache::RubyRun.instance
       </Files>
     </IfModule>


I've been to several pages and they, in my mind seem to have different instructions.
http://wiki.rubyonrails.com/rails/pages … dWithRails
http://wiki.rubyonrails.com/rails/pages/fastcgi
http://wiki.rubyonrails.org/rails/pages/RailsOnWindows
http://wiki.rubyonrails.com/rails/pages … lOnWindows


Which is the best for just instructions on installation, configuration and starting my current rails project using apache2 and fastcgi?

Also I do not have AddHandler cgi-script .cgi is this important?

I have checked and http://localhost/ takes me to the apache success page.


Many thanks from someone slightly frustrated..

Last edited by esme (2007-04-25 10:51:38)

Re: Testing large database, best server option?

I'd have used mongrel with some sort of Apache load balancing. Probably putting static files in a seperate apache virtual host (thus to move them off mongrel)

Re: Testing large database, best server option?

Thanks for your reply. I've installed mongrel and apache. I'm not entirely sure how this works with the localhost. As I'm not repaired to move it onto an online webserver yet.

Is it even possible to run a large database on a localhost with something like Apache and Mongrel? Or are these supposed to just work on a web server online where I have to have ahost.com?

I am using Windows XP by the way. Thank you.

Last edited by esme (2007-04-25 21:03:09)

Re: Testing large database, best server option?

Replace the cgi dispatcher with the fastcgi dispatcher.
In the public/.htaccess file replace

RewriteRule ^(.*)$ dispatch.cgi [QSA,L]

with:

RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]