[Vtigercrm-developers] ORDER BY modifiedtime slow...

[Alan Lord]

On 05/07/18 13:52, nilay khatri wrote:
> I would rather create a custom calculated field like "Last modified (in 
> days)" and do ordering on that. That should be faster as compared to 
> sorting on a date time field.

That's not a bad idea - would probably need to be in seconds rather than 
days though...

Or, use a timestamp column (4 byte and an integer) rather than a 
datetime (8 byte)?

Al