Re: [GENERAL] table size performace

2005-09-07 Thread A. Kretschmer
am 07.09.2005, um 1:01:11 -0700 mailte Matthew Peter folgendes: > How many rows does it take for select performance on a > table to degrade? I hope this question isn't to > ambiguous (ie lollipop licks). But seriously, 100,000? > 1,000,000? 10,000,000? With just a regular lookup on > an unique in

[GENERAL] table size performace

2005-09-07 Thread Matthew Peter
How many rows does it take for select performance on a table to degrade? I hope this question isn't to ambiguous (ie lollipop licks). But seriously, 100,000? 1,000,000? 10,000,000? With just a regular lookup on an unique index. Nothing crazy or aggregate. EX: select * from bigtable where id = 1234