Re: Performances of OnLine versus SE

Billy Wheeler (billy@west.co.za) wrote: : > : > We are currently running SE 7.11 in a UNIX environment with about 50 : > users, and the system is ridiculously slow. We have other applications : > on the system which have not suffered with the growth on the system, and : > even when I am the only user on the system, it can be VERY slow. Would : > an updrage to OnLine help, or is our software just written poorly. Any : > insight is appreciated. : > : OK, given the info to hand, there are several questions: : 1. What hardware/OS? : 2. What tools? : 3. Client/server? : Concrete things to try are: : 1. UPDATE STATISTICS. : 2. Rebuild indexes. ^^^^^^^^^^^^^^^ is there a command that will automatically rebuild all the indices other than bcheck? -Joseph