Hi Bill,
Not sure how much this will help but you can reduce the size of the meta data
or variable names being transferred.On the server side when preparing the data
to return to the client (or via SQL aliases), you can change all of the
variable names in each row to something very short instead (e.g. "first_name"
becomes "fn", "comment" becomes "cm" etc). This can really reduce the amount of
data returned, especially if there are a lot of columns.Or, return each row as
an indexed array only so there are no variable names at all to transfer along
with the data.In the client you will then have to map them back to the original
names.
I have a habit of returning the same database column names as the variable
names but I try to rename/alias them if I have time.
Here's an example in json:
[ {"id": 1, "person_name": "Jim", "address": "123 test road"}, {"id": 2,
"person_name": "Phil", "address": "63 test road"}]
(141 bytes)
now becomes
[ {"id": 1, "pn": "Jim", "ad": "123 test road"}, {"id": 2, "pn": "Phil",
"ad": "63 test road"}](111 bytes ~ 22% reduction)
Daniel
From: bilbosax <[email protected]>
To: [email protected]
Sent: Saturday, 27 August 2016, 10:50
Subject: Downloading Large Amounts of Data from Database
I am running into an issue that I believe is going to take some creative
problem solving. I have created a service to download large amounts of data
from a MySQL database, at least 50k records, but the app always times out
before all of the data can be downloaded. Has anyone ever run into this
problem and found a solution? I don't know if there is a way to download
smaller section of the database at a time and add it all together.
Thanks,
Bill
--
View this message in context:
http://apache-flex-users.2333346.n4.nabble.com/Downloading-Large-Amounts-of-Data-from-Database-tp13415.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.
