Toad World® Forums

[BUG] Team Coding performance is bad with GIT integration

Hi,

I played around the Term Coding feature.

When I used Team Coding and VCS=None (without VCS), it seems smooth.
I tried to checkout and checkin a testing package which has over 2000 lines, the speed is reasonable, open/checkin/checkout operations can be completed in < 1 sec.
Unfortunately it doesn't have history.

Then I tried to setup and enable Git for testing, operations feels very slow.
(BTW, when saving new team project, hang again, I posted this in another topic)
I enabled the VCS logging and found git operation was fast, I guess there is something wrong inside.

Let me summarize:

  1. open is slower, from <1 sec to 2-3 seconds
  2. checkout is very slow, from <1 sec to more than 20 seconds, you can check log details below, i tested the git command and it took <1 sec
  3. checkin is slower, from <1 sec to 4-6 seconds
  4. Every time I change window focus by mouse click, I saw "git.exe config user.name" was logged
  5. After some operations, not sure what happened, a strange preview on windows task bar
    sqlnav-bug-2
  6. After some operations, such like open/checkout/edit/checkin/select data/exec proc/close/quit, seems all quit but I found a sqlnavigator.exe process still in task list, not sure the steps, it doesn't happen every time

15:37:24 Time Stamp: 2020-11-25 15:37:24Connection: XXXXXXX
15:37:24 Request: git.exe config user.name
15:37:24 Response:
15:37:24 wickyhu
15:37:24 Package Body XXXXXXX checked out from Team Coding
15:37:24 Time Stamp: 2020-11-25 15:37:24Connection: XXXXXXX
15:37:24 Request: git.exe config user.name
15:37:24 Response:
15:37:24 wickyhu
15:37:24 Time Stamp: 2020-11-25 15:37:24Connection: XXXXXXX
15:37:24 Request: git.exe log --raw --date=raw "testdb/XXXXXXX.PKB"
15:37:24 Response:
15:37:24 commit e9de9f2cdce57f74bed636af45c5cbf548c0ab45
15:37:24 Author: wickyhu xxx@xxx.com
15:37:24 Date: 1606289837 +0800
15:37:24
15:37:24 Updated from Nav
15:37:24
15:37:24 :000000 100644 0000000 c6c53d9 A testdb/XXXXXXX.PKB
15:37:24 Time Stamp: 2020-11-25 15:37:24Connection: XXXXXXX
15:37:24 Request: git.exe log --raw --date=raw "testdb/XXXXXXX.PKB"
15:37:24 Response:
15:37:24 commit e9de9f2cdce57f74bed636af45c5cbf548c0ab45
15:37:24 Author: wickyhu xxx@xxx.com
15:37:24 Date: 1606289837 +0800
15:37:24
15:37:24 Updated from Nav
15:37:24
15:37:24 :000000 100644 0000000 c6c53d9 A testdb/XXXXXXX.PKB <----------look here
15:37:46 Time Stamp: 2020-11-25 15:37:46Connection: XXXXXXX <----------it took 22 seconds
15:37:46 Request: git.exe config user.name
15:37:46 Response:
15:37:46 wickyhu
15:39:16 Time Stamp: 2020-11-25 15:39:16Connection: XXXXXXX

Regards
Wicky