# Two users, 250K rows? **URL:** \ **Category:** Ask for Help\ **Created:** [April 29, 2022, 9:34pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435 "2022-04-29T21:34:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![evanwolf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evanwolf/32/42121_2.png) [@evanwolf](https://community.glideapps.com/u/evanwolf)\ **Post date:** [April 29, 2022, 9:34pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/1 "2022-04-29T21:34:52Z")
Hi. I have a spreadsheet from my health insurer that lists 250 thousand UPC numbers (13 digit string) for products it pays for through it’s OTC program. I want my family to be able to answer two questions with this app. 1. Snap a picture of a UPC bar code in 1. the store and return “Covered by Insurance” (found it) or “Not Covered”. Maybe a few hundred times a year. 2. Search the table for text and see the results to help find covered substitutes for not-covered items. I don’t need to make changes to the list or manage users. I’ll update this list no more than four times a year. We want to query There’s no business model here, no scaling of users beyond my family. Just trying to save hours of headache and heartache at the Rite-Aid, Walgreens, and Walmart in-store checkout. Can I even do this on Glide? Within the limits? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 29, 2022, 9:47pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/2 "2022-04-29T21:47:49Z")
250k rows of data is quite a bit more than glide can handle at even a technical level. I think there would be some massive bottlenecking and lag, not to mention the size of the browser cache to store all of that data locally. I think your better option would be to explore creating or using some kind of API against your google sheet or third party source, and pass that upc code though the API, and have it return a JSON result. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [April 29, 2022, 10:00pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/3 "2022-04-29T22:00:56Z")
Can you share the list of codes? I think we can make a special column that checks against them. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [April 29, 2022, 10:53pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/4 "2022-04-29T22:53:24Z")
I have a big fata also stored in the same scenario that has over 200K row but am using apps script and expand data via rows. Is there a better way ? ---
**Author:** ![evanwolf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evanwolf/32/42121_2.png) [@evanwolf](https://community.glideapps.com/u/evanwolf)\ **Post date:** [June 4, 2023, 8:27pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/5 "2023-06-04T20:27:11Z")
Is this still not possible in Glide? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 4, 2023, 8:36pm UTC](https://community.glideapps.com/t/two-users-250k-rows/41435/6 "2023-06-04T20:36:22Z")
If your plan allows it you could use the new Glide Big tables which can hold up to 10M rows > **[Glide • Big Tables](https://www.glideapps.com/docs/reference/data-sources/big-tables)** > > Scale your app with up to 10 million rows of data.