Message is stored in two records as each user should have separate copy of chat history so user could manage it's own copy of chat history. Right now management is not implemented yet but database layout is prepared to support this feature.

Hi,

Thanks for your rocket speed response. I appreciate a lot.

My requirement is there will be no deletion of history at any point of time. So If I have to maintain single copy for the better database management, Can I have any parameter configured or any other inputs that need code changes to implement this without effecting any other functionality?

Thanks in advance

Khaleel

Right now there is no such configuration parameter.

To add such a parameter would need to rewrite database access layer (mostly preparation of alternative SQL queries) which would handle alternative database schema.

Khaleel, while I agree that the way message archive is currently store could be optimized, it is not as simple or trivial as it seems. There are a few things which need to be taken into consideration:

1. As Andrzej pointed out, each user can manage own archive independently, can remove messages at any time

2. The archive is supposed to work also correctly if one of the user is on a different server

I am not saying that it impossible exceptionally difficult but it just needs a considerable amount of work to make sure it works correctly. So at the moment it is not possible to have a single copy only.

If you are interested in sponsoring of the feature implementation, we would can move this database optimization on top of our development schedule.