Project

General

Profile

Bug #165

[IMFI] Report Separation

Added by Andi Saputra about 4 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Urgent
Start date:
01/27/2021
Due date:
01/29/2021
% Done:

0%

Estimated time:

Description

Dear Developer,

mohon bantuannya untuk tuning report Separation Detail, saat ini proses pengeluaran report tersebut sangat lama.

Terlampir SP,


Files

SP - Rpt Separation Detail.txt (18.6 KB) SP - Rpt Separation Detail.txt Andi Saputra, 01/27/2021 04:43 PM
NEWQUERYIMFI.txt (19 KB) NEWQUERYIMFI.txt Saswanto Tampan, 05/19/2021 11:17 AM
2021-05-19_11-18-54.jpg (425 KB) 2021-05-19_11-18-54.jpg Saswanto Tampan, 05/19/2021 11:20 AM
#2

Updated by Saswanto Tampan almost 4 years ago

  • Status changed from Assigned to Revise
  • Assignee changed from Saswanto Tampan to Andi Saputra

proses ini walaupun sudah di tun sp nya tidak terlalu menghemat waktu, karna saat membaca data transaksi yangmencapai 900 ribu rows sudah memakan waktu pada bagian ==========================================================================================================
SELECT distinct employee_id ,
wage_type ,
dbo.GetPEN(@landscape, amount) amount_separation
FROM dbo.hr_tr0301
WHERE wage_type IN (
SELECT code
FROM dbo.hr_cu0300
WHERE is_pesangon = 'Y'
AND code NOT IN ( '5100', 'TP' ) )--IN
and pay_period_month=@period_month and pay_period_year=@period_year ==========================================================================================================
solusi potong data hr_tr0301

#3

Updated by Saswanto Tampan over 3 years ago

Boleh di coba menggunakan query yang baru (NEWQUERYIMFI), TERLAMPIR TIMMING REQUEST BERDASARKAN HASIL TESTING DI DB INTERNAL KITA MENGGUNAKAN query yang baru (NEWQUERYIMFI) 7 MENIT 35 DETIK

#4

Updated by Andi Saputra over 3 years ago

  • Status changed from QA Test to Deploy
  • Assignee changed from Andi Saputra to Saswanto Tampan

Testing ok, report sudah keluar dan sudah deploy.
Update SP, tq mang

#5

Updated by Saswanto Tampan about 3 years ago

  • Status changed from Deploy to QA Test
  • Assignee changed from Saswanto Tampan to Muhammad Bintar
#6

Updated by Muhammad Bintar almost 3 years ago

  • Status changed from QA Test to Closed
  • Assignee changed from Muhammad Bintar to Saswanto Tampan

Also available in: Atom PDF