Forum Discussion

shmulikvarsano's avatar
shmulikvarsano
Frequent Visitor
8 years ago

double loading when source = table

I have two tables: Table1 that load many XML files from folder and its take some time. I have table2 and the source = table1. The problem is that now all the XML files are loaded twice and the loa...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

shmulikvarsano,

Do you mean that the data of the two tables are loaded into Report View when you click "Close&Apply" in Query Editor? If so, this is expected behavior. Unless you uncheck "Enable load" for Table2 in Query Editor, the data of Table2 will be loaded into Report View.

Regards,
Lydia

  • shmulikvarsano's avatar
    shmulikvarsano
    Frequent Visitor
    8 years ago

    Table 1 load 300 XML file from folder and it take 10 minute. then I do some work on the data.
    The source of table2 is table1 and now all the process take 20 minthe.
    I see no reason why all the XML file loaded twice because I expect that table2 will take the data from the end of table1 and not from the beginning of table 1.

     

    thanks

      • shmulikvarsano's avatar
        shmulikvarsano
        Frequent Visitor
        8 years ago

        Thanks for all the information. but i still feel that i have no good solution to my problem.
        1. my question was on loading time and not run query time.
        2. because i do lots of work on table 2 I cant use the solution of create calculated tables on the reporting.
        3. I was expected that my tablet 2 will just take the data from the last step of table 1 and not start all the steps of table 1 from the beginning.

        4. becose table 2 depend on table 1 there is no reason why they run parallel. table 2 should start run only when table 1 finished her work.