# Load a page with 17'000 items in a app is very slow

**URL:** <https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059>\
**Category:** Ask for Help\
**Created:** [July 18, 2023, 12:06pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059 "2023-07-18T12:06:13Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 18, 2023, 12:06pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/1 "2023-07-18T12:06:13Z")

</div>

I have an events application, this one gathers around 15k to 17,000 events. The problem is that in the “events” page where I let people use their filters etc. this page never loads or has such a slow speed that the person would have had time to go make 10 coffees .

Shouldn’t there be an option to block all items from loading? For example the page have 10 items, why wouldn’t it load 10 by 10 so that it goes super fast?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [July 18, 2023, 3:49pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/2 "2023-07-18T15:49:10Z")

</div>

Is this a Classic App? I know you can do pagination in an App (Pages), but I don’t know if it keeps everything from loading.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2023, 3:57pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/3 "2023-07-18T15:57:17Z")

</div>

> [@David\_Gabler](#):
>
> I know you can do pagination in an App (Pages), but I don’t know if it keeps everything from loading.

It doesn’t, unless the source is a Big Table.

@Carter - have you considered moving this data into a Big Table? Sounds like an ideal use case…

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 18, 2023, 4:09pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/4 "2023-07-18T16:09:53Z")

</div>

Oh, nice to know… can we use Big Table with Google Sheet ?

I mean: Can we connect Big Table with Our Google Sheet, maybe Api or i dont know ? Integration maybe.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2023, 4:12pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/5 "2023-07-18T16:12:34Z")

</div>

No. Big Tables are native Glide Tables.  
You can use them in the same App as Google Sheets, but the source of a Big Table cannot be a Google Sheet.

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 18, 2023, 4:18pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/6 "2023-07-18T16:18:35Z")

</div>

And did you know If we can connect with API ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2023, 4:20pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/7 "2023-07-18T16:20:53Z")

</div>

Yes, absolutely.

In fact, you get extra API options with Big Tables - you can filter the Get Rows call with SQL type syntax.

> **[Glide • Using Glide Tables API](https://www.glideapps.com/docs/reference/data-sources/using-glide-tables-api#filtered-queries-with-big-tables)**
>
> Explore what you can do with the Glide Tables API

---

<div class="post-metadata">

**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\
**Post date:** [July 18, 2023, 4:30pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/8 "2023-07-18T16:30:39Z")

</div>

Thanks a lot ! Because it’s actually unusable at the moment, app was too slow. So i gonna Make the change.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 18, 2023, 4:34pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/9 "2023-07-18T16:34:48Z")

</div>

Cool.

Be sure to familiarise yourself with the [limitations](https://www.glideapps.com/docs/reference/data-sources/big-tables#limitations-of-big-tables) of Big Tables. There are some things that cannot be done, so you should check that before jumping in. Let me know if you have any questions.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 19, 2023, 4:35pm UTC](https://community.glideapps.com/t/load-a-page-with-17000-items-in-a-app-is-very-slow/64059/10 "2023-07-19T16:35:37Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
