Ahmed, Can you please give more detail about the requirement? Every time you need the most recent 20 records based on the timestamp?
For option 2, do you men you will pull the entire 100M rows back to the arrays? Regards, Ronnie -----Original Message----- From: Eng. Ahmed Hussien [mailto:[email protected]] Sent: Monday, December 01, 2014 1:48 AM To: [email protected] Subject: which is better in preformance? Good day, i have a situation that I call a small set of data from a very large data set multiple times with different conditions each time. For example: I'm storing 100 million records in a history table, and i'm working always for a specific algorithm on 20 records only but I get the max timestamp once, and I get the min timestamp once, and repetitively check for previous and past records of of record. Which is better? 1- querying the phoenix table every time i need data? 2-querying the phoenix once and using java arrays or lists? Ahmed
