We have 29GB development database on Sybase 12.0 on the Windows NT server. Configuration is as follows:
Windows NT Server
40 GB Hard Disk Drive
1 GHz P-III Single Processor
Acton ENZ07D Series PCI Ethernet Network Card
Paging Size 1MB (Virtual Memory)
When more than 5 people connect to the database from the client application ( using Borland Delphi Native Driver)it becomes tremendously slow.
My questions are
1>What should be the minimum configuration required for such database size and users.
2>Is there any way we can improve the speed.
I'm sure there is a techdoc put forth by Sybase, also part of discussions in Techwave's. Unfortunately. I don't have it bokk marjed and can't find it either on Sybase site. Contact your Sybase local rep in your region.
There are about a million (ok, maybe a thousand) things to check. As others have said check for index use etc. but with such a big database you're going to do *tons* of physical I/O with such tiny amounts of RAM. Beefing up to several GB would help a ton!