Share your knowledge

[#1]

Hello,

I've 3 qvw files they are initial, incremental, current.

1. Initial :
       This file creates the qvd file from scartch.

2. incremental:
       This file appends the latest data to previously qvd file.

3. Current:
       It loads the entire qvd file with lot of calculation it is taking lot of time to load entire qvd data everytime.

So what i want is, this file should hold previously loaded data and then it should retrive the latest data, after that this should append to previously loaded data. So it saves the time to reload b'coz, it doesn't require to calcualte again for previously loaded data.

I'm handling aroung 52GB qvd file in 96GB RAM.

How can i achive this? Is there anyway for this?

If you have any idea in different metthod also share me.

[#2]

Buddy,

Please give any idea to me..

[kaushiknsolanki]

Hi,

    Why dont u do calculations after getting incremental data.

    Something like this.( this is just a logic)

     If QVD is not exist.

            Get data

            Do calculation

            Create QVD

     If QVD exist

            Get time stamp from existed QVD

            Get incremated Data

            Do claulation

            Concat with existed QVD

            Replace the QVD

Regards,

Kaushik Solanki

[#4]

Kaushik,

This is good idea. I'll develop that code and i'll test it, then i'll get back you. Thanks a lot to share KT to me.

Others any idea.