I think "efficiently" is pretty open to opinion. I'm sure the flatfile becomes overwhelmed somehwere in the realm of 1 mb, but up to that point is the potential for about 5,000-6,000 links on average. That's a very wide range to look at just the high-end.
Here's what I was referring to by a server's cgi performance. This is taken from the specs for three servers my host makes use of, the slowest being a pretty average configuration:
CGI excution speeds: (primetime averages)
1) 70/sec w/bursts to 140/sec
2) 150/sec w/bursts to 230/sec
3) 190/sec w/bursts to 300/sec
As you can see, there's a very wide range in how fast the scripts can be executed, assuming the database is operating within reasonable limits.
Dan
Here's what I was referring to by a server's cgi performance. This is taken from the specs for three servers my host makes use of, the slowest being a pretty average configuration:
CGI excution speeds: (primetime averages)
1) 70/sec w/bursts to 140/sec
2) 150/sec w/bursts to 230/sec
3) 190/sec w/bursts to 300/sec
As you can see, there's a very wide range in how fast the scripts can be executed, assuming the database is operating within reasonable limits.
Dan