We have 250M records in a table and have created a pin on top the same table. It's taking more than 2 seconds to return the data in UI. But our client expecting data with in 2 seconds.
- Around 100 fields in the table.
- Created only one worksheet
- More than 50 field's Index type is Default.
- Attribution dimension is Yes for all the fields (Can we set this off since we have only one table ?)
We mostly use around 8-10 filters only in UI. so, If we turn off index for all the fields except the filter fields ,then the performance would improve?
Pls help us on this.
Brightfututure Tutorials - did you shard this table? If so, how many shards did you configure and how many nodes do you have? Some details on sharding are available at https://docs.thoughtspot.com/4.5/admin/loading/sharding.html .