why is jforum_privmsgs & jforum_privmsgs_text two different tables

[Migrated From Jforum.net]

Dear Rafael,

Can you please guide why we have two different tables for private message metadata and the actual text. since these tables grow majorly in size its a great pain to see a join every time there's a call. was it done with anything particular in mind which im totally missing.

kindly advice

thanks

Sameer
[originally posted on jforum.net by sam_avnish]

[Migrated From Jforum.net]

When you have millions of records, there is a huge difference of performance when using a single table or two tables. A single tale is a lot slower than two of them, in this case.

Rafael
[originally posted on jforum.net by Rafael Steil]