Sort:  

All right got it .

I used HiveSQL for everything related to hive but I learnt that custom json is not reliable so only for those transactions I had to shift to Hive-Engine API , any advice on this?

Posted Using LeoFinance Beta

Hive-Engine API is the way to go as their data is maintained off-chain.

Yup , doing that now.

Still i have to go through every block to retrieve the transaction details .

Right now I have stored one month data in persistent dictionary ( Shelve ) .