[Vtigercrm-developers] vt7.0.1 Slow? [No more than 6.5.0]

[Alan Lord]

The migration of this system went from 5.4.0 to 6.5.0 to 7.0.1

I just went and logged into the 6.5.0 interim stage and this one is just 
as slow.

So I am going to assume that this is not specifically to do with v7. 
More with the change introduced in v6 when the ORDER BY modifiedtime was 
introduced in list views.

I'm not sure how I'm going to address this yet (other than just removing 
the ORDER BY clause obviously), but wanted to make sure it wasn't 
misinterpreted.

It still begs the question WHY are list view style queries running when 
I want to load a single record...

Al


On 07/06/17 15:54, Alan Lord wrote:
> It would appear to be the "ORDER BY" clause which is slowing down the 
> query mentioned in the previous post (and there *is* an index on the 
> modifiedtime column).
> 
> But what I really don't get, is why it takes so long to load a single 
> record? Why are these two queries being generated *after* the ListView 
> has already been displayed and I click on one record to view it?
> 
> Can anyone else migrate a system with a decent amount of data in it and 
> try this please? As an admin user it's not too bad, but still pretty 
> poor, but as a non-admin this is unusable.