/adei/trunk

To get this branch, use:
bzr branch http://darksoft.org/webbzr/adei/trunk

« back to all changes in this revision

Viewing changes to docs/optimization/rt.txt

  • Committer: Suren A. Chilingaryan
  • Date: 2018-04-13 03:42:49 UTC
  • Revision ID: csa@suren.me-20180413034249-f7zx8mrrp7ycidhs
Support real-time export mode for status displays

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/optimization/rt.txt
 
1
DBReader
 
2
========
 
3
 - GetGroupInfo                                         - apply intervals
 
4
        SHOW TABLES
 
5
        SELECT MIN(*), MAX(*) ...
 
6
 - GetItemList                                          - headers
 
7
        SHOW COLUMNS
 
8
 - GetRawData                                           - load data
 
9
        SHOW COLUMNS                                    - construct SELECT query 
 
10
        SELECT                                          - request data
 
11
 
 
12
Optimization
 
13
============
 
14
 - Avoiding interval calculation
 
15
    experiment=*-*                                      - We don't need to find where the data ends and will not call
 
16
                                                        GetGroupInfo if 'window=#' 
 
17
    window=3600,-1                                      - The last would not work unless window has a defined size. 
 
18
                                                        Therefore, we not only request last item, but also specify window to look.
 
19
    
 
20
 - Avoiding names retrieval
 
21
    rt=skip_headers                                     - Will not call GetItemList
 
22
    rt=full                                             - Also adapts window & experiment as explained above
 
23
    
 
24
 - Loading data from the cache
 
25
    cache=1                                             - SHOW COLUMNS will not be called for DBReader & data is loaded from MySQL cache
 
26
    
 
27
 - Completely excluding source DB                       
 
28
    rt=full&cache=1