Android Question MySQL slow download queries

[bashka_abdyli]

Hi there,

I am using PHP Script and ExecuteRemoteQueryMySQL to download some date from remote MySQL DB. This is working slow because there is big data and we have here EDGE connections (which is slow).

Can someone show me how to implement compressing on server side/ uncompressing in android client?

I am open to provide any information you need.

Thanks in advance.

 

[Erel]

Please do not post duplicate questions.

http://www.b4x.com/android/forum/th...ql-database-tutorial.8339/page-16#post-191091

 

[bashka_abdyli]

Sorry Erel,

I just thought that it might be better to put into a new thread.

 

[bashka_abdyli]

Any one that can help me with this ?

 

[eps]

Okay, first of all, how much data are you requesting, is there the possibility to lessen the number of rows or the amount of columns returned?

As for compression, I'm not too sure about that, but it could be done, but you'd have to compress whatever you've got on the Server..

 

[bashka_abdyli]

Well I am limiting the rows as much as I can, but with EDGE still slow. I really need a compressing solution. Trying to figure this out since three days :-(

 

[eps]

and are you limiting the columns as well?

 

[bashka_abdyli]

Yes only the minimum required is being downloaded :-(

 

[Erel]

The simplest solution is to enable compression in the server itself.

It is explained here: http://betterexplained.com/articles/how-to-optimize-your-site-with-gzip-compression/

You will need to add a header to the request: Accept-Encoding: gzip

 

[bashka_abdyli]

What I learned from my experience is that while we are working with mobile devices every byte counts.
We should try to reduce the amount of data to minimum. One of best practice that I found out is to shorten the names of columns.

So instead of having queries like:

Select ProductCode, ProductName, ProductPrice from Products

it is much better to use in this way

Select ProductCode as [C], ProductName as [N], ProductPrice as [P] from Products

This in my scenario took the download time from MySQL to device for almost half of the time. This because JSON repeats the header row for every row.
So insted of ProductCode name now I use C (like code). This for a single row saves me 10 bytes, for 2000 rows saves me 20,000 bytes.

Works amazing now.