k*****i
发帖数: 9 | 1 Can I create thousands table in one Database? What kind of database works?
Access? oracle? My SQL?
I need almost two thousand tables. I am testing small database with access,
and haven't try such big database.
Thanks. |
h****r
发帖数: 2056 | 2 oracle and MySQL defintely do.
【在 k*****i 的大作中提到】
: Can I create thousands table in one Database? What kind of database works?
: Access? oracle? My SQL?
: I need almost two thousand tables. I am testing small database with access,
: and haven't try such big database.
: Thanks.
|
k*****i
发帖数: 9 | 3 I have two choices:
(1) two thousand tables each with 3 hundred records(rows)
(2) 3 hundred tables, each having two thouand tables.
If only considering useness, i prefer (1). Because it saves all data that I
will use in a table. I don't need to do any search. While in (2), i have to
search accross all tables by key to collect information.
Which works better?
Thanks.
access, |
k*****i
发帖数: 9 | 4 stock market, just for fun. |
s***e
发帖数: 284 | |
b*e
发帖数: 3845 | 6 two thousand tables for such a small project is definite a bad design.
【在 k*****i 的大作中提到】
: I have two choices:
: (1) two thousand tables each with 3 hundred records(rows)
: (2) 3 hundred tables, each having two thouand tables.
: If only considering useness, i prefer (1). Because it saves all data that I
: will use in a table. I don't need to do any search. While in (2), i have to
: search accross all tables by key to collect information.
: Which works better?
: Thanks.
:
: access,
|
aw
发帖数: 127 | 7 偶猜肯定是，2000只股票，300天(实际只有200多)每天价格，1)各支股票放各的表；2)各
天交易放各天的表。
哈哈哈哈。。。
【在 s***e 的大作中提到】
: 哈哈
|
