Re: Performances of OnLine versus SE

> > 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. 3. Use SET EXPLAIN to see if you have the correct indexes. 4. Profile your code. 5. Check your kernel parameters - you may need more buffers. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | | | Billy Wheeler Director The West Solutions Group | | | | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | | (W) +27 11 803 2151 (F) +27 11 803 2189 | | (C) +27 83 250 2324 (H) You must be joking! | | | +------------------------------------------------------------------------------+