English Dictionary with 163,819 rows!

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 :wink:

2 Likes

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?

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!

1 Like

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

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

1 Like

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?

Oh, I know big project must have experienced developers…

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…

Yes, yes, understand.
I’m just more about technical parts, not about relation.
May be, sometimes looks different

I have the first draft of the Pages version, try it and let me know what you think…

So… I thought that I did the fastest possible version… I was wrong!

Introducing the Instant Unlimited Data

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 :wink:

1 Like

Super cool. How did you do this?

1 Like

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.

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?

Lightning :zap: 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.

1 Like

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 :wink:

1 Like

So I tested with over 2 million rows…

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!


@slscustom.ru refresh… desktop should not have a problem with it

The same after refresh

hmmm… i Wii take down to 1 million