G'day,
We're using Matrix 3.28.10 with PostgreSQL, and our system contains about 30,000 assets. I'm working out whether to turn rollback off or not. I'm hoping to speed up our system by doing so, and the rollback function - though technically very 'cool' - doesn't seem to be all that useful for us.
Has anyone else been through this decision? Have you found rollback very useful - or do you rely on other methods to retrieve old versions of pages? Have you found turning off rollback increases the speed of your Matrix system?
Since I've been looking at the speed of the system, and particularly the speed of various database queries, I was wondering does anyone know why assetid in the database is a character field: either "character varying(15)" or "character varying(255)", depending on the table. Why isn't it an integer?
We regularly have a database query that shows up as being slow … it goes like this:
[sql]UPDATE sq_ast
SET name = 'Cron Manager', short_name = 'Cron Manager', languages = '', charset = '', force_secure = '0', updated = '2011-04-18 13:02:26', updated_userid = '12'
WHERE assetid = '16';[/sql]
This takes 60 - 100 seconds to run. The statement by itself would be expected to run in about 0.03 seconds. Does this mean it's causing other functions to execute (eg rollback database triggers, or the actions that need to be run by the cron manager itself)? Otherwise I don't understand why this takes so long.
Thanks!
Warwick
Can you be more specific about your server configuration and what in particular is slow?
Page display? The admin section?
[quote]
I was wondering does anyone know why assetid in the database is a character field: either "character varying(15)" or "character varying(255)", depending on the table. Why isn't it an integer?
[/quote]
Because you can have non-integer assetids (for example LDAP User Shadow Asset #123:uid=jdoe,ou=Staff,dc=example,dc=com)
Also, it might be worth running the System Check script (under Scripts directory). This is check for common problems that can exist on a system. This script will not fix common issues, but will warn you of potential areas that may need looking at.