Loading Data from php server to android applications

Question

I am working on this project that I cant seem to get right. Basically the application makes a request to my PHP server and displays the data on a listView.

Due to the large amount of data I have on my server, and the length of time it takes to get all the data on my listview. I decided to implement an OnScrollListener on the android side, to determine if the last item is visible, then I load more data. This I achieved by selecting all the IDs of the data I want to load when the the initial request is made. The IDs are then sorted based on my requirements (time created, points, etc) after which the first five ids are used to select the initial data which is returned to the android app along with the IDs. Then when the last item is visible, i send the next five ids from the list to a function on php which returns data corresponding to the five IDs.

So far this approach works but it is still unsatisfactory due to the amount large amount of data that needs to be processed during the initial request.

I need help with an alternative technique to achieve my objective with minimal delays while performing the initial request or subsequent request.

Any help will be much appreciated.

please guys its non-constructive if you vote my question down without giving a reason for a vote down. if you have to vote down please leave at least a comment stating why its voted down. after all this is learning environment — Princewill Obinna Iwuorie
– Princewill Obinna Iwuorie, Commented Sep 24, 2014 at 2:52

Niko Adrianus Yuwono · Accepted Answer · 2014-09-24 06:12:59Z

2

From what I read in your question, you are loading all the data at the initial request?
I suggest you to did pagination in your server side so you can minimalize the number of data, and call the next portion/page of data only when you need to do it (in this case you can implement it in OnScrollListener)

For more details about pagination
- http://www.phpfreaks.com/tutorial/basic-pagination
- http://www.phpeasystep.com/phptu/29.html
- http://code.tutsplus.com/tutorials/how-to-paginate-data-with-php--net-2928

edited Sep 24, 2014 at 6:12

answered Sep 24, 2014 at 2:47

Niko Adrianus Yuwono

11.1k8 gold badges44 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Princewill Obinna Iwuorie Over a year ago

what is paging and could you explain more?

Niko Adrianus Yuwono Over a year ago

@PrincewillObinnaIwuorie What PHP framework do you use? Paging is splitting your data (Query result) to certain pieces with some limit per pieces. For example if you have 1000 datas, you can split it to 10 pieces (100 data per pieces) and call it sequentially.

Princewill Obinna Iwuorie Over a year ago

ohh i see. but would that work on dynamic data? this is because the data I return with each request varies based on the user

Niko Adrianus Yuwono Over a year ago

@PrincewillObinnaIwuorie yeah it will, you can make the query based on the user too and then do the pagination to the data.

Princewill Obinna Iwuorie Over a year ago

cool. could you point me in the right direction for implementing it for a php server with an android client

|

Collectives™ on Stack Overflow

Loading Data from php server to android applications

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related