Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

NethCTI 3: improve performance of the history search query #5717

Closed
alepolidori opened this issue Oct 10, 2019 · 15 comments
Closed

NethCTI 3: improve performance of the history search query #5717

alepolidori opened this issue Oct 10, 2019 · 15 comments
Labels
nethcti Relative to NethCTI client or server verified All test cases were verified successfully
Milestone
NethVoice 14

Comments

@alepolidori
Copy link

Description

History search services cause low performance when the database contains lot of entries (about 1M)

Expected behavior

Performance should remain the same

Actual behavior

The rest apis linked to the query are delayed above 5 seconds timeout and so never return a results.

Components

cti server
@alepolidori alepolidori self-assigned this Oct 10, 2019
@alepolidori alepolidori added enhancement nethcti Relative to NethCTI client or server labels Oct 10, 2019
@alepolidori alepolidori added this to the NethVoice 14 milestone Oct 10, 2019
alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 10, 2019
query all history: optimize to use indexes
63de2c2 
nethesis/dev#5717
alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 10, 2019
query all history: optimize to use indexes
8b45445 
nethesis/dev#5717
@alepolidori alepolidori mentioned this issue Oct 10, 2019
Merged
alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 10, 2019
query all history: optimize to use indexes (#143)
76dd8d9 
nethesis/dev#5717
@nethbot
Copy link
Member

nethbot commented Oct 10, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.3.g76dd8d9.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.3.g76dd8d9.ns7.x86_64.rpm x86_64

alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 10, 2019
query all history: fix use of indexes
85bc49e 
nethesis/dev#5717
alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 10, 2019
query all history: fix use of indexes
366d3f3 
nethesis/dev#5717
@alepolidori alepolidori mentioned this issue Oct 10, 2019
Merged
alepolidori pushed a commit to nethesis/nethcti-server that referenced this issue Oct 11, 2019
query all history: fix use of indexes (#144)
322e88b 
nethesis/dev#5717
@nethbot
Copy link
Member

nethbot commented Oct 11, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.4.g322e88b.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.4.g322e88b.ns7.x86_64.rpm x86_64

@alepolidori
Copy link
Author

How to test

  • verify that switchboard history search is more rapid than before
  • please use a db with at least 1.5 million entries

@alepolidori alepolidori added the testing Packages are available from testing repositories label Oct 11, 2019
@nethbot
Copy link
Member

nethbot commented Oct 11, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.5.ga5c455a.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.5.ga5c455a.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 11, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.6.g0705086.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.6.g0705086.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 14, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.7.gc59269f.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.7.gc59269f.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 15, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.8.g7b523ad.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.8.g7b523ad.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 15, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.8.g9146106.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.8.g9146106.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 15, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.9.g65ab281.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.9.g65ab281.ns7.x86_64.rpm x86_64

@alepolidori
Copy link
Author

From 0 to 2 req/sec
Virtualbox machine (1 cpu, 1.5G)

@nethbot
Copy link
Member

nethbot commented Oct 15, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.10.g81200cc.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.10.g81200cc.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 21, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.11.g3d31189.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.11.g3d31189.ns7.x86_64.rpm x86_64

@nethbot
Copy link
Member

nethbot commented Oct 21, 2019

in 7.7.1908/nethesis-testing:

  • nethcti-server3-3.16.1-1.12.g4f754bf.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.16.1-1.12.g4f754bf.ns7.x86_64.rpm x86_64

@alepolidori alepolidori removed the testing Packages are available from testing repositories label Oct 23, 2019
@alepolidori alepolidori added the verified All test cases were verified successfully label Oct 23, 2019
@alepolidori
Copy link
Author

verified in production

@nethbot
Copy link
Member

nethbot commented Oct 23, 2019

in 7.7.1908/nethesis-updates:

  • nethcti-server3-3.17.0-1.ns7.x86_64.rpm x86_64
  • nethcti-server3-debuginfo-3.17.0-1.ns7.x86_64.rpm x86_64

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
nethcti Relative to NethCTI client or server verified All test cases were verified successfully
Projects
None yet
Milestone
NethVoice 14
Development

No branches or pull requests
3 participants
@alepolidori @andrea-marchionni @nethbot