以下内容来自台湾,关于IB vs SQL,大家参考(转贴)

jiangtao
CSDN创始人·极客帮创投合伙人
博客专家认证
业界专家认证
2000-06-27 12:48:00
Sorry to write in English, because I didn't install Win98 Chinese version.

It seems like not much comparison between MS-SQL 7.0 with Interbase 6.0.

Since Inprise annouced Interbase to be Open Source, I recently really have a
chance to work more on the IBX component (Interbase Express).

The last project I did for a customer:
1. Delphi BDE MSSQL Driver, with MS-SQL 7.0
2. 1.5 GB of Source Data + 2 GB of processed data = 3.5 GB
3. HP LC3 Server With 4GB HDD (By Using NT4.0 Compress Directory to reduce
data size)
4. 256 MB RAM
5. PIII 350 Single Processor
6. 10/100 base Switch

Now the month end takes 2-3 hours to finished the processing ! It seems to
me the only way to increase the performance is to upgrade the Hardware !

As MS-SQL 7.0 support simultenous access to multiple Harddisk, Load Balance
between multi-Processor, Cached Index to larger volume of Memory. With all
these features, it seems like my hardware configuration isn't powerful
enought to power up MS-SQL 7.0.

But lets be mroe reality ! we can't propose the customer to buy such a
hardware, it takes 2 to 3 times expensive !

After I try on Interbase Express, it was great !

MS-SQL 7.0
===========
Using BDE / ADO Insert 1,000,000 records take more than 90 minutes
Delete 1,000,000 records take more than 100 minutes, the delete operation
don't using stored procedure ! (Only when using Truncate is much more faster
!)
When Start a transaction, commit as soon as possible, the longer I start,
the slower it became !


Interbase
==========
1. Disable Force Write for the Database
2. Database Page Size 4096 KB
3. IBX With TIBSQL Direct Access
** All the test done under 1 Start and Commit Transaction !!

When Insert 1,000,000 records using Local Interbase, 8 min 42 sec !
When Insert 1,000,000 records using stored procedure 3 min 13 sec !
When Delete 1,000,000 records using TIBSQL in Client-Server 48 Sec !
When Edit 1,000,000 records by Stored procedure 3 min 47 sec !

With this few test, I regain confidence on Interbase, and they even support
cascade delete and update. The trigger we can write code before or after
(MS-SQL 7.0 Only Support After Action) Action.

For the first time I use MS-SQL 7.0, I find it easier to modify the table
and store procedure,
but with Interbase, I must plan it carefully, any changes to the table,
stored procedure or any meta-data that need to recreation will not be allow
if some-how any relation that current metadata refer by other metadata, this
is consider the most troublesome thing when I use interbase.

But when I plan out my design properly, this problem has been minimized !
And I am sure as Interbase go Open source, there will be tools to overcome
this problem.

MS-SQL 7.0 5 users (USD 1428) (Malaysia Selling price)
Interbase 6.0 (As far as I know - Free) (Open Source Licience Agreement)

MS-SQL 7.0 can handle very large volume of data (which is more than Terra
byte), support replication, OLAP and full text search.

But for my requirement ->
1. Data volume up to 100 GB
2. User connection up to 100 users
3. Month End process for 100 GB of Data within 1 hour

I am sure Interbase is more than enough !
...全文
132 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复

11,848

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 非技术版
社区管理员
  • 非技术版社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧