On Fri, Sep 20, 2002 at 10:53:24AM +0200, Frank Joerdens wrote:
[ . . . ]
> SELECTs are usually not hard to do
> fast anyway because especially with web apps, you'd want to have some
> kind of caching mechanism.
I put that really badly: What I was trying to say is that for web
applications in most scenarios, the select performance of the database
itself is not as crucial as some people seem to think. This is because
you're not going to get very far without some caching mechanism anyway,
and if you have a caching mechanism, it depends on how well the system
is implemented. All these benchmarks pertaining to the select
performance of the sql database behind your Apache/PHP app really put
you on the wrong track altogether. It's not how it works.
Mind you, this is still very general, and those are sweeping statements.
It all depends.
Regards, Frank