There are lots of things you can do to speed up IB, some easy, some not.
If you are running NT ( and 9=x I think) then you can set the IB server's
priority to Normal. This will make things slower but free up the cpu for
other jobs.
Are you using TCP/IP?
Store procedures are a great way of speeding up long running queries.
Perhaps some othe jhobs can be performaed asyncronously? Eg, create an
entry in a 'queue' and have a process on the server monitor the queue. This
process can then start the job and pos results back via the 'queue'. This
will free up the workstation while the server does it's thing, rather than
having to wait for a result. The queue can be a text file, or IB table or
some other thing like that.
>From: Andrew Masters <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
>Subject: [DUG]: Database Performance
>Date: Mon, 29 Nov 1999 08:54:43 +1300
>
>Hi All,
>
>I have a client with a two station peer to peer setup. The "server" is a
>PII400 with 64MB RAM running basically only my app and IB5.5. This runs
>just fine. The other workstation runs fine unless the server is being
>actively used, at which stage it grinds to a halt. The workstation is only
>a C400 with 32MB but still runs great so long as the server is idle. It
>must be a DB issue.
>
>Is there any good reference for databse tuning ? Any advice. Not sure if it
>is BDE issue or an IB issue ? Surely the hardware is sufficient for this
>setup.
>
>Regards
>Andrew Masters
>Clinical Solutions Ltd
>Auckland, NZ
>Ph: +64-9-476-0106
>Fax: +64-9-476-0108
>e: [EMAIL PROTECTED]
>
>---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
