Query Performance Improvement Results
- Members: 10 entries
- Categories: 100 entries (10 per member)
- Tags: 2000 entries (200 per member)
- Templates: 100,000 entries (10,000 per member)
- Source Codes: 100,000 to 500,000 entries (1 to 5 randomly generated per template)
- Executed 100 times with 10 threads
- Total of 1000 requests executed
Related Wiki: Query Performance Improvement ‐ Create Template
- Total request count: 1000
- Total elapsed time: 81569 ms
- Average elapsed time: 81 ms
- Total request count: 1000
- Total elapsed time: 50798 ms
- Average elapsed time: 50 ms
Related Wiki: Query Performance Improvement - Single Template Retrieval
- Total request count: 1000
- Total elapsed time: 51851 ms
- Average elapsed time: 51 ms
- Total request count: 1000
- Total elapsed time: 40136 ms
- Average elapsed time: 40 ms
Related Wiki: Query Performance Improvement - Template Update
- Total request count: 1000
- Total elapsed time: 75215 ms
- Average elapsed time: 75 ms
- Total request count: 1000
- Total elapsed time: 60483 ms
- Average elapsed time: 60 ms
Related Wiki: Query Performance Improvement - Template Search
- 26 seconds
- 16 seconds
Related Wiki: Query Performance Improvement - Template Deletion
- Total request count: 1000
- Total elapsed time: 89103 ms
- Average elapsed time: 89 ms
- Total request count: 1000
- Total elapsed time: 51689 ms
- Average elapsed time: 51 ms
Related Wiki: Query Performance Improvement - Tag Retrieval
- Total request count: 1000
- Total elapsed time: 5268308 ms
- Average elapsed time: 5268 ms
- Total request count: 1000
- Total elapsed time: 92743 ms
- Average elapsed time: 92 ms
No improvements made
Related Wiki: Query Performance Improvement - Member Information Retrieval
- Total request count: 1000
- Total elapsed time: 13072 ms
- Average elapsed time: 13 ms
No improvements made
Related Wiki: Query Performance Improvement - Member Name Duplication Check
- Total request count: 1000
- Total elapsed time: 12656 ms
- Average elapsed time: 12 ms
Related Wiki: Query Performance Improvement - Category List Retrieval
- Total request count: 1000
- Total elapsed time: 26638 ms
- Average elapsed time: 26 ms
- Total request count: 1000
- Total elapsed time: 22197 ms
- Average elapsed time: 22 ms