以快速方式加载数千个数据的最佳方式[关闭]

i have this Mobile app built with android where data is stored in the server using PHP and MySQL.

  • Android - Mobile App
  • PHP - API
  • MySQL - Database

In Mobile App, we have newsfeed. We have already 150 datas. We recoded the time, its loading 20secs of 150 datas.

Im thinking that i should load only first 10 datas and when scroll down, loads another.

What do you suggest?

Another question. Does MySQL Join makes the query fast?

Yes you can fetch the small chunk of data. For a this you need to handle the query in such a manner that it accept a page number for the data.

For example if you are fetching the record 1-10, you will pass the page number 1 and accordingly you will get a result.

Also you make use of Endless Adapter in your android app