Displaying 1 result from an estimated 1 matches for "dlyprice_close".
2010 May 19
1
Why does my RPy2 program run faster on Windows?
...elif(item[0]=="bm"):
bm=unquote(item[1])
print "cds: %s bm: %s" % (cds,bm)
print "Fetching data"
t3=datetime.now()
for row in self.cursor.execute("select * from (select * from (
select co_code,dlyprice_date,dlyprice_close from feed_dlyprice P where
co_code in (%s,%s) ) DataTable PIVOT ( max(dlyprice_close) FOR co_code IN
([%s],[%s]) )PivotTable ) a order by dlyprice_date" %(cds,bm,cds,bm)):
d1.append(str(row[0]))
v1.append(row[1])
v2.append(row[2])
t4=datetime.now()...