Have you tried this question on the international Interbase List, the
address escapes me at the moment - but mers.com sounds right. I can post the
address when I get home if no one else has. That list is supported by
Interbase staff who are very responsive.
Max
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Edward Huang
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
