# Best way to minimize latency when using large data sets

I use the Toucan in a multi-tenant situation.  I sometimes need to pull in large datasets that have thousands of lines based on duration periods.  I'm trying to decide the best way to do this... If I use a live query, it can take too long to fetch and render the data in Toucan.  Using the pre-fetched data, that dataset becomes very large and also creates delays in the rendering to the screen.    Is there a way to construct a date function with the ability to pull data over a week, or two weeks, allowing the size of the dataset to remain manageable?   Without the date picker native functionality, the user might can pick an entire month and have a very long refresh event.  Has anyone else solved this problem?

##### Post Metadata
- Posted at: over 4 years ago
- Author title: Data analytics to first measure, then improve, then maintain the performance of your Concrete Plant.  Let me show you.
- Net upvotes: 1


## Comments
### Comment 1

This should say "With the date picker native functionality...."

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: Data analytics to first measure, then improve, then maintain the performance of your Concrete Plant.  Let me show you.




## Related Product
[Toucan](https://www.g2.com/products/toucan/reviews)

## Related Category
[Embedded Business Intelligence](https://www.g2.com/categories/embedded-business-intelligence)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4