2011/12/24

SQL Language (Speed Test)

#Server version: 5.0.51b-community-nt-log
#MySQL client version: 5.0.51a
#Used PHP extensions: mysql

SELECT
s_day.s_day_id,
s_day.s_day_yesterday,
s_day.s_day_date,
s_bwibbu.s_bwibbu_id,
s_bwibbu.s_bwibbu_name,
s_bwibbu.s_bwibbu_per,
s_bwibbu.s_bwibbu_yield,
s_bwibbu.s_bwibbu_pbr,
s_bwibbu.s_bwibbu_date,
s_cv.s_cv_id,
s_cv.s_cv_cdiv,
s_cv.s_cv_eps1q,
s_cv.s_cv_eps2q,
s_cv.s_cv_eps3q,
s_cv.s_cv_eps4q,
s_cv.s_cv_eps1y,
s_cv.s_cv_eps2y,
s_cv.s_cv_eps3y,
s_cv.s_cv_eps4y,
s_cv.s_cv_roe,
s_cv.s_cv_bvps

FROM `s_day`,`s_bwibbu`,`s_cv`
WHERE s_day.s_day_id=s_cv.s_cv_id
AND s_day.s_day_id=s_bwibbu.s_bwibbu_id

AND s_day.s_day_id=2303
AND s_bwibbu.s_bwibbu_id=2303
AND s_cv.s_cv_id=2303

AND s_day.s_day_date=s_bwibbu.s_bwibbu_date

ORDER BY s_day.s_day_date DESC
LIMIT 1

Showing rows 0 - 0 (1 total, Query took 0.1676 sec)
Showing rows 0 - 0 (1 total, Query took 0.1687 sec)
Showing rows 0 - 0 (1 total, Query took 0.1676 sec)
Showing rows 0 - 0 (1 total, Query took 0.1354 sec)
Showing rows 0 - 0 (1 total, Query took 0.1351 sec)
Showing rows 0 - 0 (1 total, Query took 0.1688 sec)
Showing rows 0 - 0 (1 total, Query took 0.1349 sec)
Showing rows 0 - 0 (1 total, Query took 0.1360 sec)
Showing rows 0 - 0 (1 total, Query took 0.1354 sec)
Showing rows 0 - 0 (1 total, Query took 0.1687 sec)

***********************************************

SELECT
s_day.s_day_id,
s_day.s_day_yesterday,
s_day.s_day_date,
s_bwibbu.s_bwibbu_id,
s_bwibbu.s_bwibbu_name,
s_bwibbu.s_bwibbu_per,
s_bwibbu.s_bwibbu_yield,
s_bwibbu.s_bwibbu_pbr,
s_bwibbu.s_bwibbu_date,
s_cv.s_cv_id,
s_cv.s_cv_cdiv,
s_cv.s_cv_eps1q,
s_cv.s_cv_eps2q,
s_cv.s_cv_eps3q,
s_cv.s_cv_eps4q,
s_cv.s_cv_eps1y,
s_cv.s_cv_eps2y,
s_cv.s_cv_eps3y,
s_cv.s_cv_eps4y,
s_cv.s_cv_roe,
s_cv.s_cv_bvps

FROM `s_day`,`s_bwibbu`,`s_cv`
WHERE s_day.s_day_id=s_cv.s_cv_id
AND s_day.s_day_id=s_bwibbu.s_bwibbu_id

AND s_day.s_day_id=2303
AND s_bwibbu.s_bwibbu_id=2303
AND s_cv.s_cv_id=2303

AND s_day.s_day_date = '100/12/23'
AND s_bwibbu_date = '100/12/23'

Showing rows 0 - 0 (1 total, Query took 0.0500 sec)
Showing rows 0 - 0 (1 total, Query took 0.0501 sec)
Showing rows 0 - 0 (1 total, Query took 0.0517 sec)
Showing rows 0 - 0 (1 total, Query took 0.0509 sec)
Showing rows 0 - 0 (1 total, Query took 0.0503 sec)
Showing rows 0 - 0 (1 total, Query took 0.0170 sec)
Showing rows 0 - 0 (1 total, Query took 0.0844 sec)
Showing rows 0 - 0 (1 total, Query took 0.0847 sec)
Showing rows 0 - 0 (1 total, Query took 0.0508 sec)
Showing rows 0 - 0 (1 total, Query took 0.0507 sec)

沒有留言:

張貼留言