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)

reconfig & restart network interfaces

#ubuntu

sudo vim.tiny /etc/network/interfaces

sudo /etc/init.d/networking restart

 * Running /etc/init.d/networking restart is deprecated because it may not enable again some interfaces
 * Reconfiguring network interfaces...

Orientation to Android Training

Orientation to Android Training

Welcome to Android Training. Here you'll find a collection of classes that aim to help you build great apps for Android, using best practices in a variety of framework topics.

Each class explains the steps required to solve a problem or implement a feature using code snippets and sample code for you to use in your apps.

What you see now is just the beginning. We plan to add many more classes, expand and refine existing classes, and build Training Courses that help you enhance your apps using objective-oriented collections of classes.

Ref>

https://developer.android.com/training/index.html

https://developer.android.com/index.html