keitai-l@appelsiini.net writes:
> A lot depends on your design. Do you use indexes
>where appropriate ? Do you use persistent connections? etc,etc.
>
Thanks for the above - very kind of you. The answer is "yes" to all
points, - the Solaris thing is interesting as I had always heard that one
should avoid Solaris on intel - though I have never tried it myself.I
never expected to have to deal with these issues as available bandwidth
usually flakes out long before the box does.
*At peak* I am worried the particular site I am developing may hit
100hits/second, which - I gather - is where Mysql on Linux starts to get
upset (something to do with the way Linux 2.2 handles threads) . I am
told freebsd is better. I just wish I had a better feel about how far to
allow data redundancy (usually one byte fields over a limited number of
records) as a tradeoff against joins - but database design is not really a
keitai issue as such, **just suddenly more relevant when accessing from
smallscreen/tiny page clients as the bottleneck in the system is the
DB....**
regards,
Nick
[ Did you check the archives? http://www.appelsiini.net/keitai-l/ ]
Received on Fri Dec 8 03:31:47 2000