Incredibly slow because of superfluous alter table instructions
I'm just trying gnu social 1.2.0-beta4 and am sure, that i never get anyone using this service in this status, because it is incredibly slow. Clicking on any button or link on the web page leads to an at least 15 seconds pause, though the server is local and not a slow machine. I straced the web service and found, that the CGIs issue several "alter table" instructions to the backend database, that require 4-6 seconds to finish, each. These instructions are superfluous as the respective table already has the desired shape. Examples: ALTER TABLE ostatus_source MODIFY COLUMN method enum("push","salmon") not null comment 'source method' ALTER TABLE feedsub MODIFY COLUMN sub_state enum("subscribe","active","unsubscribe","inactive","nohub") not null comment 'subscription state' The database is a (recommended) mariadb in version 10.0.26.
The second problem i have (probably it is intended to be that way, don't know, frankly): I created groups and users in this GNU social instance. When a user posts something into a group the "status update" shows for every member. When a member presses reply and writes something, the message only shows up in the replier's own posting history. The addressee aka the writer of the original message does not get it. No other member of the group gets it either, but i think this is normal. The reply should go to the one who posted the message, that was replied to and i would expect him to see the reply. Any hint is welcome.
Thank you very much.