When im typing in the search, it becomes extr...

(Simon Chow) #1

When im typing in the search, it becomes extremely slow (e.g. Each letter literally comes out 3-5seconds after i type it in), wondering if theres any solution to this?

Thanks in advance!

(Aleksi Alkio) #2

It should not work like that. How big your datasize is?

(Simon Chow) #3

it’s around 4-5K entries

(Aleksi Alkio) #4

That amount of data should not affect in that way. What is your app name and account ID if it’s okay to look about it?

(Simon Chow) #5

of course, here’s the link to the app FYI, but i’m afraid its only available

in chinese for now. Appreciate the help! appsheet.com - AppSheet AppSheet appsheet.com

(Aleksi Alkio) #6

I tested the app and I can see only very small delay… maybe 0.2…0.3 sec after typing. I believe this is the same app that you sent with another post. Could it be possible to use the view (table or deck) without photos. When your user opens the detail view, it will download the photo then (like one by one).

(Simon Chow) #7

Thanks for the testing, yes this is the same app I mentioned in the other post. The delay actually happens primarily when you do the search in the mobile apps (sorry I should have provide you with the links https://itunes.apple.com/app/id1344132335) understood the concern but pictures in the deck view is actually quite important, is there any other ways we can speed up the loading. One of the reason for the slow reaction is possibly due to the fact that it tries to search for all the data in the database whenever I input a new letter, hence I’m wondering if it’s possible to search the database after the user has input all the text in the search bar but not searching everytime they try to key in a letter tbar? My樓 on the App Store itunes.apple.com

(Aleksi Alkio) #8

Add that Usersetting feature as Praveen wrote and arrange a slice with that value. If you filter the data a lot, check what happens with the search.

(Praveen Seshadri (AppSheet)) #9

The deck and table view do not lay out all the data initially (and so all the photos are not downloaded initially). They only are fetched in on demand (unless you have enabled offline content, which I’ll assume is not the case here). So that cannot be the explanation. Wrt dynamic filtering, we actually wait for a pause while typing the search term before filtering starts.

(Simon Chow) #10

Thanks guys, so is the only solution to this would be slicing the data?

(Aleksi Alkio) #11

Well… if you would use the security filter for your data that we discussed on another post, that will have better affect for your app than just a slice.

(Aleksi Alkio) #12

It should not work like that. How big your datasize is?

(Simon Chow) #13

it’s around 4-5K entries

(Aleksi Alkio) #14

That amount of data should not affect in that way. What is your app name and account ID if it’s okay to look about it?

(Simon Chow) #15

of course, here’s the link to the app FYI, but i’m afraid its only available

in chinese for now. Appreciate the help! appsheet.com - AppSheet AppSheet appsheet.com

(Aleksi Alkio) #16

I tested the app and I can see only very small delay… maybe 0.2…0.3 sec after typing. I believe this is the same app that you sent with another post. One thing you should think about… when you have lot of rows, all your photos will be downloaded at the same time. Could it be possible to use the view (table or deck) without photos. When your user opens the detail view, it will download the photo then (like one by one). If you have 5000 rows of photos to download, it’s a lot of data and it will affect your app very easily.

(Simon Chow) #17

Thanks for the testing, yes this is the same app I mentioned in the other post. The delay actually happens primarily when you do the search in the mobile apps (sorry I should have provide you with the links https://itunes.apple.com/app/id1344132335) understood the concern but pictures in the deck view is actually quite important, is there any other ways we can speed up the loading. One of the reason for the slow reaction is possibly due to the fact that it tries to search for all the data in the database whenever I input a new letter, hence I’m wondering if it’s possible to search the database after the user has input all the text in the search bar but not searching everytime they try to key in a letter tbar? My樓 on the App Store itunes.apple.com

(Aleksi Alkio) #18

Add that Usersetting feature as Praveen wrote and arrange a slice with that value. If you filter the data a lot, check what happens with the search.