node省市区三级数据性能测评

‘use strict‘;

const Controller = require(‘egg‘).Controller;

class HomeController extends Controller {
  async index() {
    const { ctx } = this;
    ctx.body = ‘hi, egg‘;
  }

  async city() {
    const { ctx } = this;
    console.time("sql")
    const provinces = await this.app.mysql.select(‘provinces‘)
    const citys = await this.app.mysql.select(‘cities‘)
    const areas = await this.app.mysql.select(‘areas‘)
    console.timeEnd("sql")
    console.time(‘cal‘)
    provinces.forEach(province => {
      let provinceid = province.provinceid
      province.children = []
      citys.forEach(city => {
        city.children = []
        if (city.provinceid === provinceid) {
          province.children.push(city)
        }
        let cityid = city.cityid
        areas.forEach(area => {
          if (area.cityid === cityid) {
            city.children.push(area)
          }
        })
      })
    })
    console.timeEnd(‘cal‘)
    const result = {
      status: 1,
      data: provinces,
    }
  
    ctx.body = result;
  }
}

module.exports = HomeController;

‘use strict‘;

const Controller = require(‘egg‘).Controller;

class HomeController extends Controller {
  async index() {
    const { ctx } = this;
    ctx.body = ‘hi, egg‘;
  }

  async city() {
    const { ctx } = this;
    console.time("sql")
    let provinces = await this.app.mysql.select(‘provinces‘)
    let citys = await this.app.mysql.select(‘cities‘)
    let areas = await this.app.mysql.select(‘areas‘)
    console.timeEnd("sql")
    console.time(‘cal‘)
    for (let i = 0, len = citys.length; i < len; i++) {
      let city = citys[i]
      city.children = []
      let cityid = city.cityid
      for (let j = 0, len1 = areas.length; j < len1; j++) {
        let area = areas[j]
        if (area.cityid === cityid) {
          city.children.push(areas.splice(j, 1)[0])
          len1--
          j--
        }
      }
    }
    provinces.forEach(province => {
      let provinceid = province.provinceid
      province.children = []
      for (let i = 0, len = citys.length; i < len; i++) {
        let city = citys[i]
        if (city.provinceid === provinceid) {
          province.children.push(city)
          citys.splice(i, 1)
          len--
          i--
        }
      }
    })
    console.timeEnd(‘cal‘)
    const result = {
      status: 1,
      data: provinces,
    }
  
    ctx.body = result;
  }
}

module.exports = HomeController;