I found that table 'asset' does't have indexes for columns changes and created.
It's very important for queries with ordering. In admin list f.e.

So I suggest to add it.

CommentFileSizeAuthor
asset-add-index-for-columns-changed-created.patch739 bytesvtkachenko

Comments

andrew.mikhailov’s picture

andrew.mikhailov commented
Status: Needs review » Reviewed & tested by the community

Hello! I think this is good additional for this module, because it increases searching.
Please apply this patch for me it works good.
Best regards.

IRuslan’s picture

IRuslan commented
Status: Reviewed & tested by the community » Fixed

Pushed to dev. Thanks for work.

  • IRuslan committed 503a7bd on 7.x-1.x authored by vtkachenko 
    Issue #2457605 by vtkachenko, Andrew.Mikhailov: Add index for table '...

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.