[Vtigercrm-developers] vtiger slowing down (a lot)

Rubén A. Estrada Orozco rulotec1 at gmail.com
Fri Sep 30 16:36:48 GMT 2022


Thank you for your tips guys!

Tom, I hadn't thought about it, but changing the default lists makes a lot
of sense. You also mention mysql having to order by modifiedtime lots of
records. Checking vtiger_crmentity, I see there is no index for
modifiedtime:

[image: image.png]

since by default all "All" lists are ordered by modifiedtime, shouldn't
there be an index for that? I'll try adding it and see what happens.


Angelo, how do you go about adding indexes? how do you choose what indexes
to add?



Saludos

Rubén
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220930/a24afee5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 116100 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220930/a24afee5/attachment-0001.png>


More information about the vtigercrm-developers mailing list