# English Dictionary with 163,819 rows! **URL:** \ **Category:** Project Showcase\ **Created:** [July 3, 2021, 4:11am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645 "2021-07-03T04:11:11Z")\ **Posts on this page:** 20\ **Page:** 4
**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:** [January 7, 2023, 9:59am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/61 "2023-01-07T09:59:22Z")
trust me… it is a masterpiece… the interaction between Glide and GS is just amazing… try to transfer data back and forth between Glide and GS… I think my app is doing it faster than Glide itself. and I know all of it doesn’t make sense for people who deal with databases below 20k rows… but trust me… upload over 100K rows to google sheets with at least 10 columns of big data… and you will see… GS will start choking and Glide will freeze… then you will fully appreciate what I’m doing 😉 ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 7, 2023, 10:31am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/62 "2023-01-07T10:31:05Z")
Some question, dear UZO! You apps looks like b2c, now i working on b2b pages is ERP in insurance sales. So set of users will retrieve sets of data, not just one word and pages must to show different statistics and also data changes. How do you think your script be helpfully and performance? ---
**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:** [January 7, 2023, 10:31am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/63 "2023-01-07T10:31:59Z")
instant… is all about the size of the payload… and data structure… but as you see 80 million characters, from another source… under 1 sec. filtered and sorted! ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 7, 2023, 10:39am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/64 "2023-01-07T10:39:47Z")
For example a small size^ One screen must to shown 11 insuranse product and you need to calculate, for example sales qty, amount sum, price averange on one year, for example 10000sales ---
**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:** [January 7, 2023, 10:42am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/65 "2023-01-07T10:42:14Z")
as I said… 10K x 3 variables… just 30K to compute… less than 3 sec, if on the outside source… inside…less than 0.1 sec ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 7, 2023, 10:48am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/66 "2023-01-07T10:48:20Z")
Ok! For small size I looks for internal. But for big size? 3 second just for click next 11 products? Hou do you sink have David bit it for half second for 10M rows? If David can, so, much more Glide creators can earn money, not only experienced coders? ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 7, 2023, 10:50am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/67 "2023-01-07T10:50:20Z")
Oh, I know big project must have experienced developers… ---
**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:** [January 7, 2023, 10:53am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/68 "2023-01-07T10:53:28Z")
I don’t wanna mess with David… I’m bringing paid Pro customers to Glide every month… and David did not kick me out for advertising myself too much… I know I’m a little pain in his A…s… but it is a profitable relationship for both sides… ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [January 7, 2023, 10:58am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/69 "2023-01-07T10:58:02Z")
Yes, yes, understand. I’m just more about technical parts, not about relation. May be, sometimes looks different ---
**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:** [January 9, 2023, 4:30am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/70 "2023-01-09T04:30:17Z")
I have the first draft of the Pages version, try it and let me know what you think… > **[External Data Source](https://external-data-1.glide.page)** > > Eternal Data source for Glide Pages with Stripe and PayPal integrations, Address Picker, Custom Emails, PDF Invoice Creator. Unlimited rows and updates. ---
**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:** [April 6, 2023, 9:37am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/71 "2023-04-06T09:37:43Z")
So… I thought that I did the fastest possible version… I was wrong! Introducing the **Instant Unlimited Data** ![Screen Shot 2023-04-06 at 5.33.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/631b040cf6ba7f03dbd5ee0dbe8ccdd612a2d8bf.jpeg) > **[Data JSON](https://data-json.glide.page)** > > Ultimate, instant, unlimited rows Now I can rest in peace on this subject… there is no faster solution! Ps. Unless I figure out how to read your mind, and show the data you need before you start typing 😉 ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [April 6, 2023, 12:03pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/72 "2023-04-06T12:03:58Z")
Super cool. How did you do this? ---
**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:** [April 6, 2023, 1:19pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/73 "2023-04-06T13:19:43Z")
Thank you! I just added a million rows of data, and it is running smoothly… please let me know if someone has a problem loading this app… I will add more to test the maximum that Glide can handle. ![Screen Shot 2023-04-06 at 9.16.29 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5fbcc2d9273251f6876c78e59ff49cc0ebb2996b.jpeg) I just tested it on my old cellphone, and it took 7 seconds to load it… not too bad… probably with data over 200K rows… I will have to map it. @Eric_Penn is it loading fast? How many seconds? ---
**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:** [April 6, 2023, 3:05pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/74 "2023-04-06T15:05:25Z")
Lightning ⚡ fast It took about ~5 seconds to load when I tested just now on iPhone 13 Pro Max with decent Wi-Fi. There’s a small lag when entering search terms but I mean… I remember the first version you had. The progress you’ve made is very impressive. ---
**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:** [April 6, 2023, 3:06pm UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/75 "2023-04-06T15:06:34Z")
I crossed 1 million rows on a free plan, baby!!! LOL Tnx for testing. Under 200K, there is absolutely no waiting. I will add 1 more million tomorrow 😉 ---
**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:** [April 7, 2023, 8:14am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/76 "2023-04-07T08:14:00Z")
So I tested with over 2 million rows… ![Screen Shot 2023-04-07 at 4.03.51 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98e4a16787521b94c33623e1e2688d915593bfd8.jpeg) 15 seconds on the desktop… The Mobile did not load data. ;-( So the conclusion is… over 1 million… I have to map the data. Update… it did load on mobile…LOL. 35 seconds! ![340195506_211511931495778_1800407993581360623_n](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf6a8db7ebe40d8c85248fefdccbbc95252357a0.jpeg) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 7, 2023, 9:36am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/77 "2023-04-07T09:36:54Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7bf3082b7c4738ac009853b544b2b042d5912f24.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0f7758604d36bb295aa78fd10a7680970eef81a.png) ---
**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:** [April 7, 2023, 9:38am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/78 "2023-04-07T09:38:12Z")
@slscustom.ru refresh… desktop should not have a problem with it ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [April 7, 2023, 9:41am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/79 "2023-04-07T09:41:46Z")
The same after refresh ---
**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:** [April 7, 2023, 9:43am UTC](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645/80 "2023-04-07T09:43:03Z")
hmmm… i Wii take down to 1 million [Previous page](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645.md?page=3) [Next page](https://community.glideapps.com/t/english-dictionary-with-163-819-rows/28645.md?page=5)