SQLの駅結合度付ビュー about ares HOT 1 CLOSED

#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3
import time

DB = sqlite3.connect("ares.sqlite")

def lineid():
    for i in range(100):
        cur = DB.execute(u"SELECT * FROM station_kilo NATURAL JOIN line WHERE lineid=69")
        for i in cur: pass

def linename():
    for i in range(100):
        cur = DB.execute(u"SELECT * FROM station_kilo NATURAL JOIN line WHERE linename LIKE '東海道'")
        for i in cur: pass

def get_time(function):
    begin = time.clock()
    function()
    end = time.clock()
    return end - begin

print "lineid: ", get_time(lineid), "sec"
print "linename: ", get_time(linename), "sec"