sg
发帖数: 83 | 1 一。改造的核心之一，应当是用数据库来存放信息。印象中现行的FBBS是
用自己的一套东西来管理文件，这必然影响reliablity & Scalablity。
若能弄到免费的话，偶觉得Oracle 8i是最好的Backend Database engine.
二。要考虑n-tier的体系结构。象现在买卖提BBS这样的负载，一定要用
Client-Server也行，但成本是高昂的。偶觉得无论从reliablity，或
Scalablity来考虑，都应该采用n-tier的archetechure。一开始可以用
3-tier的，即一台Web Server，一台Database Engine，两台机器之间用
高速网络连接。将来还可以考虑用一台机器来作Telnet Server。这样万
一Web Server或Telnet Server当掉，还有另一个作BACKUP。
三。近期改造目标应是允许2000人同时上站，最终应允许5000-10000人
同时上站。此外，个人感觉在有许多用户时，JSP和Servlet的表现好象
更好些。 |
w**********k
发帖数: 1135 | 2 Good guy, 与我想的差不多 :-)
【在 sg 的大作中提到】
: 一。改造的核心之一，应当是用数据库来存放信息。印象中现行的FBBS是
: 用自己的一套东西来管理文件，这必然影响reliablity & Scalablity。
: 若能弄到免费的话，偶觉得Oracle 8i是最好的Backend Database engine.
: 二。要考虑n-tier的体系结构。象现在买卖提BBS这样的负载，一定要用
: Client-Server也行，但成本是高昂的。偶觉得无论从reliablity，或
: Scalablity来考虑，都应该采用n-tier的archetechure。一开始可以用
: 3-tier的，即一台Web Server，一台Database Engine，两台机器之间用
: 高速网络连接。将来还可以考虑用一台机器来作Telnet Server。这样万
: 一Web Server或Telnet Server当掉，还有另一个作BACKUP。
: 三。近期改造目标应是允许2000人同时上站，最终应允许5000-10000人
|
a*****i
发帖数: 4391 | 3 1: Oracle 8i is very complex. YOu would probably have to hire a DBA to admin
the system well. MySQL is a very nice alternative. /. runs on mySQL btw.
2: Improving the performance is very important. I support the idea of using
servlet.
【在 sg 的大作中提到】
: 一。改造的核心之一，应当是用数据库来存放信息。印象中现行的FBBS是
: 用自己的一套东西来管理文件，这必然影响reliablity & Scalablity。
: 若能弄到免费的话，偶觉得Oracle 8i是最好的Backend Database engine.
: 二。要考虑n-tier的体系结构。象现在买卖提BBS这样的负载，一定要用
: Client-Server也行，但成本是高昂的。偶觉得无论从reliablity，或
: Scalablity来考虑，都应该采用n-tier的archetechure。一开始可以用
: 3-tier的，即一台Web Server，一台Database Engine，两台机器之间用
: 高速网络连接。将来还可以考虑用一台机器来作Telnet Server。这样万
: 一Web Server或Telnet Server当掉，还有另一个作BACKUP。
: 三。近期改造目标应是允许2000人同时上站，最终应允许5000-10000人
|
b****e
发帖数: 1275 | 4 just because mysql is easy to admin doesn't mean it's the best choice
price aside, oracle beats any other db hands down
further more.. just for db purposes.. 8i or 703 or wahtever doesn't make
too much difference i think
【在 a*****i 的大作中提到】
: 1: Oracle 8i is very complex. YOu would probably have to hire a DBA to admin
: the system well. MySQL is a very nice alternative. /. runs on mySQL btw.
: 2: Improving the performance is very important. I support the idea of using
: servlet.
|
w*****g
发帖数: 198 | 5 well, oracle takes way too much resource for its functions
mysql is good enough la, or postgresql
since this bbs's equipment doesn't seem to be powerful enough
【在 b****e 的大作中提到】
: just because mysql is easy to admin doesn't mean it's the best choice
: price aside, oracle beats any other db hands down
: further more.. just for db purposes.. 8i or 703 or wahtever doesn't make
: too much difference i think
|
a*****i
发帖数: 4391 | 6 Granted, oracle is the best performance commercial DB to my knowledge.
However, that doesn't justify for the cost of running the monster on the machine.
Besides, it would take days to figure out what went wrong in the system if any
incident occurs.
I still think MySQL is the best choice. It is small, easy to install and get it
to run. It has a handful of tools available, and since BBS is not that much a
database that requires a lot efficiency or security concern, it is good enough
for the set up
【在 b****e 的大作中提到】
: just because mysql is easy to admin doesn't mean it's the best choice
: price aside, oracle beats any other db hands down
: further more.. just for db purposes.. 8i or 703 or wahtever doesn't make
: too much difference i think
|
b****e
发帖数: 1275 | 7 mysql doesnt' support cursor (or has itr changed now?)
for example.. for same subject reading.. how would you implement
it in mysql? (let's assume there're 200 responses for a popular
subject..)
【在 w*****g 的大作中提到】
: well, oracle takes way too much resource for its functions
: mysql is good enough la, or postgresql
: since this bbs's equipment doesn't seem to be powerful enough
|
a*****i
发帖数: 4391 | 8 I am sure you can use Perl, PHP or Java servlet to achieve the same
goal . It will not be that efficient, but again, we are not running a bank
here. :)
【在 b****e 的大作中提到】
: mysql doesnt' support cursor (or has itr changed now?)
: for example.. for same subject reading.. how would you implement
: it in mysql? (let's assume there're 200 responses for a popular
: subject..)
|
