Have any benchmarks been done with this module?

When I enable it, MySQL shoots up to 90% CPU utilization and stays there. When I disable it, it returns to normal. (Although I can only do so by actually deleting the file from the modules directory, as the site stops responding once the module is enabled).

During that period I'm unable to actually get the module to function (that is, to edit a node and assign permissions to it) because the server just won't respond to requests at all. I thought perhaps this was due to the initial queries that activating the module runs, but this seems not to be the case.

I'm trying it out on a fairly large site (3000+ users, 8000+ nodes).

Comments

AlanChandler’s picture

AlanChandler commented

I don't know mysql at all, as I am using postgres on my site, but I have been looking at the node_privacy_byrole module recently and the following strikes me as a possible problem.

When anyone is editing the node - and perhaps when they are viewing it, a query takes place on the node_access table.

It seems to have a primary key of nid, gid, realm, but I bet the view query is doing a query with only the nid (node id) supplied.

What happens if you create an index for nid on this table?

ankur’s picture

ankur commented