DB optimization

[LNKBOOT]

Hi, i would like to add some index to get better performance but i can not because we are not root of db system

CREATE INDEX cl_participants_idx_call_id_recording_url ON cl_participants (call_id,recording_url);
CREATE INDEX dn_idx_value ON dn (value);
CREATE INDEX extension_idx_fkiddn ON extension (fkiddn);
CREATE INDEX myphone_callhistor_idx_dnowner ON myphone_callhistory_v14 (dnowner);
CREATE INDEX users_idx_fkidextension ON users (fkidextension);

where to find root credential, i dont remember in wich file they are stored, thank you ? can you add those index ion your next update please ?

Thank you

 

[AWS2P]

Nothing is granted to be done on 3CX DB, and you dream awake,you will never get any password from 3CX, this is obviously their garden only.

 

[VoIPTools]

This is something you should NEVER consider doing. 3CX does not support making any changes to the database, not even new indexes. If you do, and you get caught, your PBX will be flagged as UNSUPPORTED. Don't do it. I asked for permission to make a tiny PostgreSQL configuration change (not even a database change) and 3CX was very clear -- no changes of ANY kind.

 

[LNKBOOT]

OK thank you for your replies , maybe someone of the team can take care of my message and do the changes for next updates ?

 

[VoIPTools]

Get your 3CX partner to submit the idea on the Ideas forum.