Hello! I have a layer with 3 million points, of the 3 million there are roughly 70,000 distinct coordinates (but each of the 3 million points also have coordinates).
I only need to display the 70,000 unique points but I need to be able to query the 3,000,000 records (using JS API), a simplistic view of the data below:
ID SITE LAT LONG PRODUCT
1 1 1.1 1.1 Product 1
2 1 1.1 1.1 Product 2
3 1 1.1 1.1 Product 3
4 2 2.2 2.2 Product 1
5 2 2.2 2.2 Product 6
6 2 2.2 2.2 Product 9
7 3 3.3 3.3 Product 4
8 3 3.3 3.3 Product 6
9 4 4.4 4.4 Product 1
0 4 4.4 4.4 Product 2
...
3000000 .....
If I publish this layer then all 3 million points are plotted which is not great for performance.
For plotting terms I only need to plot the distinct points BUT for querying terms I need to query the entire 3 million rows (using a QueryTask).
I think the solution may be to create a parent child relationship but Im struggling to see how I can filter on PRODUCT in the child table and then de-reference back to the parent record.
Thanks for your help!
Chris.
