Re: onconfig

In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. > >I issue a select * from tablename. The table has 8000 rows in it. The >response time is in the region of 5 -10 minutes. Now, I know a table >scan will be done but the response is obviously not acceptable. I've >managed to find a ONCONFIG file which, I believe contains the database >tuning paramters. How can I tell if this is the file being used? Does >anyone have any idea where I can find the startup script to validate the >db config file name? > >They are having serious response time problems on a development >application using fairly complicated SQL but until I get past this basic >problem (architectural/tuning), I won't look at the complicated stuff. >Let's get the simple things going first. > >Thanks in advance to anyone who can help me out. >Sue Online WorkGroup Server is a new product - basically a cutdown version of Online DSA. I'm not sure which DSA paramaters are will not be in your onconfig file. Could you e-mail your onconfig file. PS In case anyone wonders where I was earlier this week I was installing NT 3.51 so I could install the Online Workgroup Server Trial CD we just received at work!. The NT installer got confused with my multi-boot Win95/Linux (PD Unix) setup and so I've been trying to get this machine back into a state where I can boot Win 95 for my Internet connection! You're a few days ahead of me Sue!!! Now if I can just get some NT drivers for my CD-ROM.... -- David Williams