Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <33666728.6C39@mailbox.swipnet.se>, Nils Paulsson <nils.pauls
son@mailbox.swipnet.se> writes
>
>Hi there.
>
>I'm in the middle of setting up my first Informix server (Win-NT) and I
>would realy need some usefull benchmark test to do the initial setting
>for the database parameters.
>
>Does anyone know if there is any test database+client software for
>bringing some pressure on the server. By the way, the DBMS is going to
>serve some on-line transaction applications.
>
Get the applications and use them as a benchmark - nothing else will
accurately simulate the workload you will get with the system.
NOTE: 90% of all performance improvements come from
1. Finding the slow running sql statements in the application,
running them in dbaccess after running "SET EXPLAIN ON". Looking at
the sqexplain.out file produced and adding appropriate indicies.
2. Set OPTCOMPIND = 0 so the indicies will be used.
3. Running update statistics so the indicies will be used.
4. In 4GL preparing often used sql to reduce parsing/optimization
overhead.
5. Adding more BUFFERS as long as swapping does not occur i.e.
getting good read/write cacheing.
>Thanks in advance.
>
>/Nils Paulsson
--
David Williams
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.