# Workaround for searchable database containing 100,000+ rows? **URL:** \ **Category:** Ask for Help\ **Created:** [June 16, 2021, 4:31pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050 "2021-06-16T16:31:11Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![tourglide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tourglide/32/26487_2.png) [@tourglide](https://community.glideapps.com/u/tourglide)\ **Post date:** [June 16, 2021, 4:31pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/1 "2021-06-16T16:31:11Z")
Hi there, I’m in the process of building a new app that contains a searchable database of a long list of songs (100,000+). The issue is with the current Glide row limits (personal and paid), it would seem that the app would not be feasible for the Glide platform, which is unfortunate since Glide is a great platform. Might there be any known workarounds or other options, perhaps a mechanism to pull a database feed from a separate resource? The 100,000+ song list wouldn’t need to be modified, rather just searched and referenced. Thank you! ---
**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 18, 2021, 1:56pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/2 "2021-06-18T13:56:10Z")
You’ll have to be mindful of your data structure. Row Owners, `=filter` & `=vlookup` are your friends. Using spreadsheet formulas could get you there but will be some loss of performance. ---
**Author:** ![ptrnelson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ptrnelson/32/28509_2.png) [@ptrnelson](https://community.glideapps.com/u/ptrnelson)\ **Post date:** [June 30, 2021, 8:06pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/3 "2021-06-30T20:06:39Z")
Hey Eric, can you expand on this a bit. I’m in a similar pickle as @tourglide but have around 350K rows. 😕 ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [June 30, 2021, 8:16pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/4 "2021-06-30T20:16:23Z")
I had an issue where I needed to do a post code lookup in my app to return the town and German ‘Land’. It’s a 5 digit code (PLZ) … with minimal and unreliable logic… and 12,000 possibilities. The solution is to put that into a separate Google sheet (import csv). Next send a webhook with the PLZ to integromat, which does a Google Sheet lookup to pick the right values, then does a search for the row that is using that plz. It’s very quick, and saves rows in my app. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [June 30, 2021, 9:25pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/5 "2021-06-30T21:25:31Z")
And how does Integromat “report back to your app though? ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [June 30, 2021, 9:32pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/6 "2021-06-30T21:32:19Z")
Making a lookup and paste the values on the row that you are using in order to update the data on the app i think ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [June 30, 2021, 9:43pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/7 "2021-06-30T21:43:32Z")
This should give you an idea of the scenario 🙂 @Darren_Murphy is the expert - this is one of his 🙂 ![Screenshot 2021-06-30 at 23.41.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2c2e2ba1f2d173681730e02fac456f08b6e43d48.jpeg) ![Screenshot 2021-06-30 at 23.42.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64ab1ee5de44b21adf259f1cbfb57a1d8b1a6956.jpeg) ![Screenshot 2021-06-30 at 23.42.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/838fbd9e705143aae28ac9d7bcb4c109c029a5aa.jpeg) ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [June 30, 2021, 9:49pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/8 "2021-06-30T21:49:09Z")
Sure, but obviously still with the usual 2-3 min delay? ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [June 30, 2021, 9:53pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/9 "2021-06-30T21:53:59Z")
The webhook is sent immediately to Integromat - so about 2 seconds Then integromat runs every minute (much better than Zapier) The script in integromat takes 6 - 14 seconds to run (with the end point of writing to GS) Then I have my sad wait time for the Google sheet: - if I am updating a row, then GS updates Glide on a 3 min cycle - if I am adding a row, then GS syncs immediately with Glide (so about 5 - 8 seconds) One of these days we will have a webhook to write into Glide directly (esp if you need Glide Tables). Oh that will be a happy day… 🙂 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [June 30, 2021, 10:03pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/10 "2021-06-30T22:03:39Z")
Just use glide action to set columns in google sheets with a values to filter, and have gs do the filtering… and glide to show that sheet data, it will take 1 to 5 seconds to complete ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [June 30, 2021, 10:10pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/11 "2021-06-30T22:10:28Z")
It depends on the size of the data set. An array formula with a lookup in GS runs every time… every row. This could get painfully slow very quickly, and is unnecessary because ideally the value is fixed once you get it. A lot depends on the use case and the specifics of the App. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [June 30, 2021, 10:11pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/12 "2021-06-30T22:11:34Z")
I tested on 32k rows… runs smoothly ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [June 30, 2021, 10:13pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/13 "2021-06-30T22:13:00Z")
What if Glide supported, optionally, waiting for a webhook response. The app could show a spinner whilst waiting and write the response into a column. Almost like a REST API call. Now that would be a nice feature. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [June 30, 2021, 10:46pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/14 "2021-06-30T22:46:07Z")
Glide has a limit of 50k searchable rows - **per sheets in _Google Sheets_** - and they’ll be searchable Is this limit increase in Glide tables @jason? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [June 30, 2021, 10:49pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/15 "2021-06-30T22:49:29Z")
Btw @Messias_Carvalho already done a video about it ☝🏼 Take a look > [@Limite de 25000 lignes](https://community.glideapps.com/t/limite-de-25000-lignes/27004/4): > > I ran tests on my account, where I have +175,000 rows available and it is possible to reach 50,000 rows for each table on the google sheet. here’s in the video when i show it. [[Testando a capacidade do Glide! Será que suporta?] ](https://www.youtube.com/watch?v=yoBqc6861rk) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [June 30, 2021, 11:42pm UTC](https://community.glideapps.com/t/workaround-for-searchable-database-containing-100-000-rows/28050/16 "2021-06-30T23:42:00Z")
just tested with 120k rows… under 3 seconds