Android Question Cache problems with Samsung T3

[brodmuehler]

Hallo

I am looking for some help since I am really getting insane. I attached my project in form of a zip file. The problem I have is that I want to run this app on my 7'' Samsung T3. Everything works fine but when I try to show all datasets of the database table "starts" then neither the webview approach nor the table approach works. I think in both cases my tablet is running into cache issues.

Would it be possible if you could have a look and give me an advise what I could do to make it work. Is there any way to better use the cache available. Is my code that bad that it uses too much cache. I am really getting at my limit and would appreciate any help.

Thanks a lot in advance.
Kind regards
René

 

[Erel]

The database file is missing. Which error do you get with the Table view?

 

[brodmuehler]

The database file is missing. Which error do you get with the Table view?

Hallo Erel. Thanks for your quick response. And apologies that i missed to attach the database file. The file is now attached to this text. I am not getting an error message at all. The tablet just hungs up as soon as I call the activity "AllStarts" where the tableview is implemented. The activity "AllStarts" is called from the "Starts" activity. Funny enough, I also installed your sample app for the tableview and that works fine. A bit slow on my Samsung T3, but alright. That can only mean that something is wrong in my code or the tablet is not able to cope with my app. I am pretty close to throw this piece of hardware in the bin. Thanks again for your help. Rene

 

[Erel]

There are still some image files missing. Are you testing it in Release mode?

 

[brodmuehler]

There are still some image files missing. Are you testing it in Release mode?

Erel, I have no idea what happened and why some of the files are missing. I always test in debug mode and there where no warnings or messages that files are missing. I used the zip-function in B4A to generate the estartliste.zip-file. In addition I zipped the Files folder with all image files and the database. I hope now everything is complete.
Thanks a lot.
René

 

[Erel]

You haven't added all the files to the Files tab. Go to the Files tab and press on Sync.

I'm running it now. However can I reproduce this issue?

 

[brodmuehler]

Hallo Erel
Please apologize that I did not sent you all the files. I wasn't aware of the fact that I have to synchronize the Files tab. I thought that the IDE would pick all necessary files from the folders. That should not happen again.

Have you seen any major bugs in my app that might cause the problem of running out of memory or cache or causes the app to stop?

Again, thanks a lot for all your help and patient. If there is any advice, e.g. good books or anything elese I could use to overcome this issue please let me know.

Regards
René

 

[Erel]

I haven't delved into the code. I don't remember seeing anything special.

 

[brodmuehler]

Hallo erel. I found a little workaround and it now running fine. I found out that my tablet can only cope with a limited number of datasets. Otherwise the stringbuilder or also a readall from a file causes an outofmemory and the tablet hangs up. I slightly modified your exechtml routine in dbutils such that i introduced an upper and a lower limiter. That way i was able to define a range of datasets that i want to show in the webview. In addition, i introduced four navigation buttons dor the user tonflip between pagges of 100 datasets up and down. This approach works fine and also has the advantage that the database can grow but the webview always works with a defined number of datasets. Pwrhaps the approach is of interest for you as well and you want to add a second limiter to your routine. Thanks a lot for all your patient and support. As I said before, your software is great and your support outstanding. Without b4a Inwould never have been able to develop my app. Kind regards rene.

 

[brodmuehler]

With the above said, this question can be closed for now. Thanks again. Kind regards Rene