Database Dilemma... Please help.

[Tyler Strickland]

On 04/06/2006 11:35 AM, Blake B. wrote:
> On Apr 6, 2006, at 11:23 AM, Nick Barker wrote:
> 
>> The question is how wide are your rows and how well do you index.
>> Personally I find this the biggest issue on speed with any database.
>> Good luck finding someone that has 100 million records.  I cannot help
>> you there.
> 
> Craigslist has 100,000,000 rows in their archive database.  They list it 
> in this case study:  
> http://www.mysql.com/it-resources/case-studies/mysql-craigslist-casestudy.pdf 

You might check out the case study page as well - it references, for 
example, a system at Cox with 2 billion+ rows.

--Tyler