[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