(07-05-2021, 03:32 PM)remkonoteboom Wrote: You mentioned that the TaskElementWdg can be really slow.
In task_element_wdg.py, there is a preprocess function, is it possible you can time it for me?
Code:import time
start = time.time()
.... <all the code in preprocess> ...
print("time: ", time.time() - start)
time: 0.07304883003234863
For a 10 sobjects. 4 ghz cpu
Code:
request_id: 140253759268608 - #0000002
timestamp: 2021-07-05 18:52:39
user: admin
simple method: <function ApiXMLRPC.get_widget at 0x7f8f7747d1f0>
ticket: ac8a7066c7451e28de0
( 'tactic.ui.panel.TableLayoutWdg',
{ 'args': { 'element_names': 'preview,name,script,storyboard,general_checkin,checklist,duration,notes,task_pipeline_vertical,task_edit,approve_assets,assets_in_episode,shot,description,timestamp',
'expand_on_load': True,
'group_elements': [],
'search_keys': [ 'complex/scenes?project=dolly3d&id=174',
'complex/scenes?project=dolly3d&id=175',
'complex/scenes?project=dolly3d&id=177',
'complex/scenes?project=dolly3d&id=178',
'complex/scenes?project=dolly3d&id=179',
'complex/scenes?project=dolly3d&id=180',
'complex/scenes?project=dolly3d&id=181',
'complex/scenes?project=dolly3d&id=182',
'complex/scenes?project=dolly3d&id=183',
'complex/scenes?project=dolly3d&id=184',
'complex/scenes?project=dolly3d&id=194',
'complex/scenes?project=dolly3d&id=198',
'complex/scenes?project=dolly3d&id=199'],
'search_type': 'complex/scenes',
'show_select': '',
'show_shelf': False,
'table_id': 'main_body_table_6876',
'temp': True,
'view': 'table'},
'libraries': { 'spt_button': True,
'spt_calendar': True,
'spt_help': True,
'spt_html5upload': True,
'spt_mobile_table': True,
'spt_popup': True,
'spt_tab': True,
'spt_table': True,
'spt_view_panel': True},
'values': { 'json': '[{"prefix":"filter_mode","filter_mode":"and"},{"prefix":"custom","custom_enabled":"on","filter_type":"_column","custom_column":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"code","main_body_relation":"is","main_body_value":"SCENES00176"},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"login","main_body_relation":"is '
'not","main_body_value":"Animator"},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"login","main_body_relation":"is '
'not","main_body_value":"listy"},{"prefix":"search_ops","levels":[0,0],"ops":["and","and"],"modes":["child","child"]},{"prefix":"simple","handler":"tactic.ui.filter.KeywordFilterElementWdg","element_name":"keywords","value":""},{"prefix":"simple","handler":"tactic.ui.filter.TextFilterElementWdg","element_name":"name","op":"=","value":""},{"prefix":"keyword","value":"shorts"},{"prefix":"search_limit","Prev":"","Showing":"1 '
'- '
'14","Next":"","search_limit":"","limit_select":"100","custom_limit":"","Showing_last_search_offset":"0"},{"prefix":"group","group":"","interval":"","order":"","show_retired":""}]'}})
time: 0.07304883003234863
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
SQL Query Count: 218
BVR Count: 1116
Sending: 1691.6044921875 KB
Num SObjects: 522
Duration: 0.737 seconds (request_id: 140253759268608 - #0000002)If i remove tasks column completely:
Code:
request_id: 140011924068096 - #0000006
timestamp: 2021-07-05 19:01:38
user: admin
simple method: <function ApiXMLRPC.get_widget at 0x7f572bca01f0>
ticket: ac8a7066c7451e28de0
( 'tactic.ui.panel.TableLayoutWdg',
{ 'args': { 'element_names': 'preview,name,script,storyboard,general_checkin,checklist,duration,notes,task_edit,approve_assets,assets_in_episode,shot,description,timestamp',
'expand_on_load': True,
'group_elements': [],
'search_keys': [ 'complex/scenes?project=dolly3d&id=174',
'complex/scenes?project=dolly3d&id=175',
'complex/scenes?project=dolly3d&id=177',
'complex/scenes?project=dolly3d&id=178',
'complex/scenes?project=dolly3d&id=179',
'complex/scenes?project=dolly3d&id=180',
'complex/scenes?project=dolly3d&id=181',
'complex/scenes?project=dolly3d&id=182',
'complex/scenes?project=dolly3d&id=183',
'complex/scenes?project=dolly3d&id=184',
'complex/scenes?project=dolly3d&id=194',
'complex/scenes?project=dolly3d&id=198',
'complex/scenes?project=dolly3d&id=199'],
'search_type': 'complex/scenes',
'show_select': '',
'show_shelf': False,
'table_id': 'main_body_table_7032',
'temp': True,
'view': 'table'},
'libraries': { 'spt_button': True,
'spt_calendar': True,
'spt_help': True,
'spt_html5upload': True,
'spt_mobile_table': True,
'spt_popup': True,
'spt_tab': True,
'spt_table': True,
'spt_view_panel': True},
'values': { 'json': '[{"prefix":"filter_mode","filter_mode":"and"},{"prefix":"custom","custom_enabled":"on","filter_type":"_column","custom_column":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"code","main_body_relation":"is","main_body_value":"SCENES00176"},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"login","main_body_relation":"is '
'not","main_body_value":"Animator"},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"login","main_body_relation":"is '
'not","main_body_value":"listy"},{"prefix":"search_ops","levels":[0,0],"ops":["and","and"],"modes":["child","child"]},{"prefix":"simple","handler":"tactic.ui.filter.KeywordFilterElementWdg","element_name":"keywords","value":""},{"prefix":"simple","handler":"tactic.ui.filter.TextFilterElementWdg","element_name":"name","op":"=","value":""},{"prefix":"keyword","value":"shorts"},{"prefix":"search_limit","Prev":"","Showing":"1 '
'- '
'14","Next":"","search_limit":"","limit_select":"100","custom_limit":"","Showing_last_search_offset":"0"},{"prefix":"group","group":"","interval":"","order":"","show_retired":""}]'}})
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
WARNING: site is empty
SQL Query Count: 63
BVR Count: 279
Sending: 440.6396484375 KB
Num SObjects: 101
Duration: 0.282 seconds (request_id: 140011924068096 - #0000006)
Memory: 100824 KB
Increment: 3512 KBNote: Duration: 0.282 seconds, almost 3 times faster without task element widget
(07-05-2021, 03:32 PM)remkonoteboom Wrote: You mentioned that the TaskElementWdg can be really slow.I think it's slow because its heavy layouts, js scripts and etc structures, which is really heavy and browser having hard time rendering it. But for user it's just 2 combos, and some labels...
In my opinion combo boxes with users should be replaced with interactive search box, which will load users as you type, or click to see whole list. At this time it's loading all users from particular groups, and this operation not cached, and making lots of db queries.
Same with the pipeline processes. There is no point having 10 preprocessed combos on each, while it can be replaced with interactive elements and do query only when necessary.
(My English is bad today, hope you understand)
And also:
Sending: 1691.6044921875 KB
vs
Sending: 440.6396484375 KB