Re: Help with Informix !!! Really Important!!!

i do not really agree with Chris, start tuning it:!!!!! if 512MB ram why BUFFERS 200000 # Maximum number of shared buffers are you using 800 MB for your buffer cache??? this will NOT perform. i agree that you need to configure a tempdbs!!! also onstat -p would be nice; it sure sounds like missing indexes or since TBLSPACE_STATS 1 # Maintain tblspace statistics goto sysmaster select * from sysptprof where seqscans > 1 and check where you get seq scans on. maybe you are comparing apples and eggs eq join two tables where tab1.col = int and tab2.col = char Superboer. "scottishpoet" <dryburghj@yahoo.com> wrote in message news:<1114101342.303527.161970@f14g2000cwb.googlegroups.com>... > 9.24? > > 9.14 maybe > > 7.24 maybe > > 9.24?you sure > > can you run onstat -V and post the output? > > mweall...@panacea.co.uk wrote: > > What about the old faithful "UPDATE STATISTICS". I would suggest > that > > the queries are working on out of date statistics. If "UPDATE > > STATISTICS" doesn't improve matters reading up on UPDATE STATISTICS > in > > the documentation. > > I'd even suggest using the IDS 10 documentation set as this has a > > search facility that will enable you to get to the right sections of > > the manuals very quickly. > > > > regards > > > > Malcolm > > > > Christopher wrote: > > > Add more RAM. > > > > > > In my experience with the combination of IDS 9.40 and Windows 2003, > > 512 > > > MB is just not enough. The Task Manager Performance tab showed > > memory > > > usage pegged. We jumped straight to 2 GB and that solved a lot of > > > problems. > > > > > > Next, I notice you have no temp dbspace listed. That can be a big > > > problem. > > > > > > Other than that, I would urge you to read the Performance Guide at > > > http://publibfp.boulder.ibm.com/epubs/pdf/ct1t9na.pdf > > > > > > This will not only give you good advice about how to resolve most > > > performance issues, it will give advice on how to identify them. > > > > > > You are using a vanilla, default onconfig file. Unfortunately, > there > > > is no such thing as a vanilla, default application. Without > knowing > > > more about your application, no one will be able to give you the > > Really > > > Important!!! help you need. > > > > > > Sincerely, > > > > > > Christopher Coleman > > > > > > President > > > Kansas City Informix Users Group > > > www.iiug.org/kciug > > > > > > Database Analyst > > > Medication Management > > > Mediware Information Systems, Inc.

Ok, i have created a new dbspace for the database with 300.000 MB and another one for the operations and temp tables also with 300MB. The applications runs under Informix, and have a Persistence Driver (Hibernate). It can have connected up to 100 users at the same time. If you need to know sonethimg else about my app that can help to perform databse, please ask me about it... Thanks a lot.