NYCPHP Meetup

NYPHP.org

[nycphp-talk] database performance

Roland Cozzolino rcozzol at optonline.net
Fri Oct 28 09:17:55 EDT 2005


Flat data no problem, but hierarchies of that size?  Better ways to do 
that outside of a DB.

George Schlossnagle wrote:

>On Oct 28, 2005, at 12:44 AM, Roland Cozzolino wrote:
>
>  
>
>>That is a very valid point, ...however (there has to be some sort of
>>argument) ... if you have a table with N-million rows, chances are  
>>your
>>DB design isn't very good.
>>    
>>
>
>That claim reads to me like 'no data set reasonably has 3 million  
>distinct members in it', which is kinda obviously bogus.
>
>I manage a number of ~1T sized databases.  I can guarantee you that  
>there are a number of tables in them that have N-million rows, where  
>N is not small.  Data points on customer behavior spanning a couple  
>years, things like that.
>
>George
>_______________________________________________
>New York PHP Talk Mailing List
>AMP Technology
>Supporting Apache, MySQL and PHP
>http://lists.nyphp.org/mailman/listinfo/talk
>http://www.nyphp.org
>
>  
>



More information about the talk mailing list