Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

QVD read and write at the same time and consequences

Hi All,

We have very big QVD of 2 GB size and one QVW(task) is reading data from that file.At the same time if another QVW file trys to write into that same QVD what will happen ?

Any ideas ?

Thanks,

Chiru

1 Solution

Accepted Solutions
ian_wilson
Former Employee
Former Employee

Scenario 1:  Read/Read - Task 1 (Read) opens the QVD file then Task 2 (Read) opens the file while Task 1 still has it open.  All tasks run fine.

Scenario 2:  Write/Read - Task 1 (Write) opens the QVD file then Task 2 (Read) also opens the file while Task 1 still has it open.  Task 2 will fail since Task 1 has the file opened exclusively and Task 1 will run fine.

Scenario 3:  Read/Write - Task 1 (Read) opens the QVD file then Task 2 (Write) also opens the file while Task 1 still has it open.  Task 2 will fail since it will not be allowed to open the file exclusively while there are other tasks reading from it.  Task 1 completes fine, Task 2 results in a failure.

View solution in original post

2 Replies
ian_wilson
Former Employee
Former Employee

Scenario 1:  Read/Read - Task 1 (Read) opens the QVD file then Task 2 (Read) opens the file while Task 1 still has it open.  All tasks run fine.

Scenario 2:  Write/Read - Task 1 (Write) opens the QVD file then Task 2 (Read) also opens the file while Task 1 still has it open.  Task 2 will fail since Task 1 has the file opened exclusively and Task 1 will run fine.

Scenario 3:  Read/Write - Task 1 (Read) opens the QVD file then Task 2 (Write) also opens the file while Task 1 still has it open.  Task 2 will fail since it will not be allowed to open the file exclusively while there are other tasks reading from it.  Task 1 completes fine, Task 2 results in a failure.

chiru_thota
Specialist
Specialist
Author

Thanks Ian for clear explanation!