Android Question Cache problems with Samsung T3

brodmuehler

Member
Licensed User
Longtime User
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é
 

Attachments

  • estartliste.zip
    96.1 KB · Views: 130

brodmuehler

Member
Licensed User
Longtime User
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
 

Attachments

  • estartliste.sqlite.zip
    41.1 KB · Views: 125
Upvote 0

brodmuehler

Member
Licensed User
Longtime User
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é
 

Attachments

  • estartliste.zip
    96.1 KB · Views: 136
  • Files.zip
    123.7 KB · Views: 140
Upvote 0

brodmuehler

Member
Licensed User
Longtime User
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é
 
Upvote 0

brodmuehler

Member
Licensed User
Longtime User
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.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…