Regarding reading data from mysql or json file

pureboy

I have a web site to load the images with GPS exif information and add the markers on the google map to generate the routes.

I have a routes consisted with 88 images which means need to read the 88 record from the mysql database.

the sql is like

select lat,lng, item_name, Originaldatetime, image_path,street_name from maps where map_id=xxxx order by UTC.

At beging, I mixed up the php code to read all records from the mysql table with while loop and the javascript to show the maps together.

The page stacked in blank page waiting the php to read all the records from the table.
To improve the user experience, I taken away to code the read the data from the mysql db, and leave the javascript only looks after rendering the maps and html elements.

php script do all the heavy lifting job by connect to the db and read all the data from table and read all record into arrays in while loop. once it array generated,

header("Content-type:application/json");
$myjson = fopen("maps/$user/$map_id.json", "w") or die("Unable to open file!");
fwrite($myjson, json_encode(array($arrLat,$arrLng,$arrDT,$arrTimeDiff,$arrSPD,$full_path,$arr_item_name,$width,$height,$arr_street)));
        fclose($myjson);

php has export the arrays into json encoder in 2 way, firstly, it echo to the javascript ,2ndly, it export the json file on the server disk.

This provide the options on how javascipt the read the json data.

In javascript:

1.                //$.getJSON('map_data.php?map_id='+map_id, function (data) {
2.              $.getJSON('maps/1511215176230503.json', function (data) {

2 ways to read the json data, 1st option is simply wait for respond from the php to read all the data from the mysql db, and loop through each element of the json file.
2ndly, read the json from the json file which is pre generated by php code.

to read data from the table cost around 7018 ms while read from json file is 328 ms.

It suggested that developer need to export json to files read from my sql data. the benefit is if you need to read the json data more than once, only the first read need to consume a lot of time.

It improve the user experience.

有图有真相

jin-1234

如果为了省重复性操作的网络时间，生成json文件的话。你的程序需要能够有选择性的更新json内容，否则json数据可能会和数据库的实际数据产生差别。比如你可以让程序每n分钟读取db，刷新json内容

pureboy

jin-1234 发表于 2017-12-17 00:03
如果为了省重复性操作的网络时间，生成json文件的话。你的程序需要能够有选择性的更新json内容，否则json数 ...

没错，有实时性的问题。
对于相对静态的数据，这方法是是更加适合。

在这个应用里面，主要是读取已经生成的图像地址，图像的GPS信息和时间信息，所以只要一次生成JSON文件就足够了。

谢谢你有耐心看完这对堆砌在一起的文字。