放弃RODBC写数据库了# Stock
P*H
1 楼
感觉sqlSave和sqlUpdate来更新数据库里面的股票数据非常笨拙。还是单独做一个外部
程序来更新数据效率比较好。R从数据库里面读数据，生成的Report存成本地文件。不
知道各位R大师是不是也是这样做的？
程序来更新数据效率比较好。R从数据库里面读数据，生成的Report存成本地文件。不
知道各位R大师是不是也是这样做的？
i*e
2 楼
I would suggest that you do some analysis first to see
1. how much data do you plan to save per day? total size?
2. what is the most usage pattern (reading? writing? searching?)?
3. based on 1 & 2, you could either use the "save" function provided by R if
it suffices your need or come up with some custom binary format which is
easy to search and provide an R interface to load/write/search it.
1. how much data do you plan to save per day? total size?
2. what is the most usage pattern (reading? writing? searching?)?
3. based on 1 & 2, you could either use the "save" function provided by R if
it suffices your need or come up with some custom binary format which is
easy to search and provide an R interface to load/write/search it.
相关阅读