From: Matthew Smillie <M.B.Smillie@...>
Date: 2006-05-30T08:03:29+09:00
Subject: Re: MySql limitations??


On May 29, 2006, at 22:37, Harish TM wrote:
> On 5/30/06, Harish TM <harish.tmh@gmail.com> wrote:
>>
>> hi...
>>        I need to store something like a couple of million rows is  
>> a MySql
>> table. Is that ok or do I have to split them up. I intend to index  
>> each of
>> the colums that I will need to access so as to speed up access.  
>> Insertion
>> will be done only when there is very little or no load on the  
>> server and
>> time for this is not really a factor. I also do not have any  
>> constraints on
>> disk space.
>>
>>      Please let me know if I can just use MySql as it is or if I  
>> need to
>> make some changes
>>
>> harish
>>
>
> Just in case you are wondering why this is here its because I need  
> to access
> all this data through Ruby modules. So maybe the question should  
> have been:
>
>       Is the existing ruby module to do this fast enough and reliable
> enough or are there some additional modules that I can use?
>
> harish

Well, the details might depend on the answer to the following questions:

1. Which existing ruby module do you mean?
2. How fast do you need it to be?

At a guess, though, I'd say that ActiveRecord could likely deal with  
what you need to do.  At least well enough to use it to start with  
and find out for real via testing/benchmarking.

matthew smillie.