Re: Performance issues of one vs. two split tables.

On Mon, 14 May 2007, PFC wrote:

>     I did something like that on MySQL some time ago.
>     In the Users table there was stuff that other users need to see (like
> his login name, etc), and stuff that only this user needs to see (like his
> preferences).
>     So, when displaying posts in the forum, for instance, only a small
> part of the fields in the Users table was needed, the rest was just dead
> weight, that made the table unable to fit in RAM.
>     So I split the table, and it was faster.
>
>     However, you can also buy more RAM...

   Or, use Views without paying more.

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863