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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
