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

Question

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?

Answer 1

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