I have heard that NT SP4 is recomended for using with Interbase, not NT SP5
as it slows down Interbase. I have no first hand experience of this though.
Have you tried using FIB or Interbase Express? This would eliminate the
baggage of the BDE.
Nahum
-----Original Message-----
From: Edward Huang [mailto:[EMAIL PROTECTED]]
Sent: Monday, 1 November 1999 12:25
To: Multiple recipients of list database
Subject: [DUG-DB]: Interbase Performance
Hello, Group,
A question related to Interbase on Windows NT performance.
We are new to Interbase, and just installed a new system using Interbase
5.1 on Windows NT 4 Server SP5. We are doing extensive transactions
(select/insert/update), and should that the performance is not as good as
we expected.
Disregarding the detail performance measurement, we tested the performance
on two different spec PCs. One is Ceon 500 CPU, 256MB RAM, Super FAX
SCSI-II harddisk, another one is AMD-166 CPU (slower than Pentium 133),
64MB RAM, normal IDE harddisk. The strange thing is that both machine
giving the same (or say similar) performance.
In both situation, we run client and server on the same machine, and access
database via BDE TQuery. Both take about 1 second to run 4 SQLs (2 select
SQL with one or non record return, 2 Update or Insert SQL). We use same
configuration for BDE on both machine (almost default, with Drive Flag
4096, Shared Autocommit), and high spec machine configured Interbase Server
with more memory cache size.
The question is why they give the same performance with so different
hardware spec? (we hope one should at least twice faster than another
one). Are there any special configuration we can do to let the high spec
machine give high performance?
Help please.
Regards,
--------------------------------------------------------------
Edward Tianjun Huang Today Software Limited
97 Great South Road
Email: [EMAIL PROTECTED] (Company) Remuera
[EMAIL PROTECTED] (Private) Auckland
--------------------------------------------------------------
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
