+1
HI,
I am trying to calculate avg for 10 gb data and show it on graph in browser. Query takes around 16 sec. For smaller chunk of data, it is around 1 sec. Should I divide the table into multiple partitions and run queries in parallel. Or Am I missing something.
+1HI,
Thanks for your reply, It is simple query for calculating moving average. The query time is now less than 1 sec. I took the help of db designer and it asked me to create a new projection.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
