Re: Is Informix SE best than Informix DSA?

jicg <1812j30c@sendanet.es> wrote: :We have Informix DSA 7.12, we not get performance with it. :Simples queries not get the same or best performance with DSA :than with STANDARD-ENGINE when we processed a complex query of bigs :tables. The machine is paralyze. :If theres anybody who want to talk about it. :Thank. Informix OnLine DSA 7.12 is much faster than SE *in most cases*. We have also been able to execute some things faster on SE in some cases. It depends on your machine, amount of memory, proper setup and tuning and so on. You might want to start with telling us the machine type, amount of memory, operating system, how you have set up your diskspace (raw or cooked, if raw what device have you used), amount of buffer memory and other key configuration parameters, the database (tables involved, amount of data in them, indexing), which update statistics command you have run, the sql you execute and whatever else you think might be relevant. With some information someone will help you. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org