Project

General

Profile

Tasks #12953

Stock Movement report Very Slow..!!!!!

Added by Rijas P about 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Ijas Ahammed
Start date:
01/17/2024
Due date:
% Done:

0%

Estimated time:

Description

Dear Muzammil,

As you know, this is a main report to understand the all movements of items. But most of our users not using this screen due to the loading time.

Files

78b74634-a221-4526-933b-0fd56bea7b62.mp4 (1.69 MB) 78b74634-a221-4526-933b-0fd56bea7b62.mp4 Rijas P, 01/17/2024 11:42 AM
eurolog.txt (48.1 KB) eurolog.txt ShabeerAli Tp, 01/17/2024 05:00 PM
long-run-queries.txt (1.6 MB) long-run-queries.txt ShabeerAli Tp, 01/17/2024 09:13 PM

History

#1

Updated by ShabeerAli Tp about 1 year ago

Backend log attached

#2

Updated by Ijas Ahammed about 1 year ago

  • Assignee changed from MUZAMMIL S to Noufal K
#3

Updated by Noufal K about 1 year ago

  • Assignee changed from Noufal K to System Admins Team

Please share long-running queries.

#4

Updated by Sharil Ali about 1 year ago

  • Assignee changed from System Admins Team to ShabeerAli Tp

Shabeer

Please do the needful

#5

Updated by ShabeerAli Tp about 1 year ago

long-running queries attached

#6

Updated by Noufal K about 1 year ago

  • Assignee changed from Noufal K to Ijas Ahammed

Ijaz, Done a few query optimizations. please check now getting output in less than 10 seconds.

#7

Updated by Ijas Ahammed about 1 year ago

  • Status changed from New to Resolved

Yes. It's fast now.

Dear Rijas, please check now.

#8

Updated by Rijas P about 1 year ago

  • Status changed from Resolved to Closed

It's too fast now. Thanks

#9

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF