(keitai-l) Re: 2 tech questions

From: Nick May <nick_at_kyushu.com>
Date: 12/08/00
Message-id: <fc.000f76100004c61b3b9aca00de3a905a.4c61d@kyushunet.com>
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