search for: databasejournal

We have created a Ruby on Rails website which is based on searching a table of 70,000+ object. Each object searched then returns a list of id''s in another table, of about 30,000. The id''s are listed for each object in the first table. The problem is, when we search for object which are very frequently met, the query runs extremely slowly, and after looking at the query log,

Hi, I was lucky enough to learn ruby a bit before starting to learn rails. That has helped quite a bit. Unfortunately, my knowledge of SQL and databases in general started from zero when approaching rails, and I find that trying to "get" database stuff from the context of rails books and documentation is holding me back. Can anyone recommend a free online pdf or website that will

I have a site running the current version of Centos 4.2, it has a shopping cart running on it and runs slow and times out at random. The cart is a simple php package using a MySQL database backend. Can any one think of ways to improve the speed in MySQL and Apache, I've had the cart checked by the software vendor, it's working like it should, they are pointing to MySQL or Apache and

I''ve used mysql for quite some time now. Other than crashing when the partition gets full, I''ve had no problems with it. But I''ve heard great things about postgres and have seen some people say it''s much superior to mysql. So, with a Rails application, is there any reason why I would want to learn/use another DB besides mysql? Any pragmatic benefits?

Hi, I am a RoR newbie and I''ve been experimenting with different databases (mySQL, PostgreSQL, etc.) and different table types (MyISAM vs. InnoDB). Is there a preferred database/table type for RoR development. I like how MySQL''s InnoDB tables enforce referential integrity, but these tables require a lot more storage space then MyISAM tables. For everyone with a lot of RoR