VedaSupport Forum
Synchronising takes too long time - Printable Version

+- VedaSupport Forum (http://forum.kanors-emr.org)
+-- Forum: VEDA Front End (http://forum.kanors-emr.org/forumdisplay.php?fid=2)
+--- Forum: Questions and Observations (http://forum.kanors-emr.org/forumdisplay.php?fid=7)
+--- Thread: Synchronising takes too long time (/showthread.php?tid=746)



Synchronising takes too long time - MohammedAbiAfthab - 07-06-2019

Hello, I am experiencing pretty long time(around 3-4 hours) while synchronising my files in VEDA. I observed that when the synchronization reaches one of my specific scenario files this happens. Any idea why this is happening? If required I can share the file. Regards Abi Afthab


RE: Synchronising takes too long time - pdas - 07-06-2019

(07-06-2019, 07:55 PM)MohammedAbiAfthab Wrote: Hello, I am experiencing pretty long time(around 3-4 hours) while synchronising my files in VEDA. I observed that when the synchronization reaches one of my specific scenario files this happens. Any idea why this is happening? If required I can share the file. Regards Abi Afthab
Hello MohammedAbiAfthab, Could you please provide more details on that? Sharing file will help. Thanks. 


RE: Synchronising takes too long time - MohammedAbiAfthab - 10-06-2019

(07-06-2019, 08:43 PM)pdas Wrote:
(07-06-2019, 07:55 PM)MohammedAbiAfthab Wrote: Hello, I am experiencing pretty long time(around 3-4 hours) while synchronising my files in VEDA. I observed that when the synchronization reaches one of my specific scenario files this happens. Any idea why this is happening? If required I can share the file. Regards Abi Afthab
Hello MohammedAbiAfthab, Could you please provide more details on that? Sharing file will help. Thanks. 
Hello Patha Das, While synchronizing the base year template, scenario files and subRes files of the model, it's taking long time. Especially I can observe that when I make changes to a particular scenario file and then try to synchronize it, it is consuming very long time (3-4 hours). This excel file also has the largest size among all my other files (1.4 MB). Whether this happens usually? I am attaching that particular file here. Regards Abi Afthab


RE: Synchronising takes too long time - pdas - 10-06-2019

(10-06-2019, 02:12 PM)MohammedAbiAfthab Wrote:
(07-06-2019, 08:43 PM)pdas Wrote:
(07-06-2019, 07:55 PM)MohammedAbiAfthab Wrote: Hello, I am experiencing pretty long time(around 3-4 hours) while synchronising my files in VEDA. I observed that when the synchronization reaches one of my specific scenario files this happens. Any idea why this is happening? If required I can share the file. Regards Abi Afthab
Hello MohammedAbiAfthab, Could you please provide more details on that? Sharing file will help. Thanks. 
Hello Patha Das, While synchronizing the base year template, scenario files and subRes files of the model, it's taking long time. Especially I can observe that when I make changes to a particular scenario file and then try to synchronize it, it is consuming very long time (3-4 hours). This excel file also has the largest size among all my other files (1.4 MB). Whether this happens usually? I am attaching that particular file here. Regards Abi Afthab
Hello MohammedAbiAfthab, From the attached excel workbook it is evident that you are trying to insert lots of entries (6723*2 + 7203*1 + 5283*2), which is reason of long time for syncing. Please use ~TFM_DINS table instead of ~TFM_INS, which should be faster. Remember that you cannot use filters inside ~TFM_DINS table and also you have to specify all the required dimensions for specifying an attribute (refer attribute master). Thanks.


RE: Synchronising takes too long time - MohammedAbiAfthab - 10-06-2019

(10-06-2019, 02:27 PM)pdas Wrote:
(10-06-2019, 02:12 PM)MohammedAbiAfthab Wrote:
(07-06-2019, 08:43 PM)pdas Wrote:
(07-06-2019, 07:55 PM)MohammedAbiAfthab Wrote: Hello, I am experiencing pretty long time(around 3-4 hours) while synchronising my files in VEDA. I observed that when the synchronization reaches one of my specific scenario files this happens. Any idea why this is happening? If required I can share the file. Regards Abi Afthab
Hello MohammedAbiAfthab, Could you please provide more details on that? Sharing file will help. Thanks. 
Hello Patha Das, While synchronizing the base year template, scenario files and subRes files of the model, it's taking long time. Especially I can observe that when I make changes to a particular scenario file and then try to synchronize it, it is consuming very long time (3-4 hours). This excel file also has the largest size among all my other files (1.4 MB). Whether this happens usually? I am attaching that particular file here. Regards Abi Afthab
Hello MohammedAbiAfthab, From the attached excel workbook it is evident that you are trying to insert lots of entries (6723*2 + 7203*1 + 5283*2), which is reason of long time for syncing. Please use ~TFM_DINS table instead of ~TFM_INS, which should be faster. Remember that you cannot use filters inside ~TFM_DINS table and also you have to specify all the required dimensions for specifying an attribute (refer attribute master). Thanks.
ok I see. Thank you very much for your suggestion. I will do that. Regards Abi Afthab