Re: Slow Query time

"Raj B. Kondapaneni" wrote: > > Hi, > We are running INFORMIX-OnLine Version 7.24.UC2 on a Sun Ultra > Enterprise 2. We are using cold fusion to connect to Informix database to > run SQL queries. It takes about 2 min. or so to run a query that has about > 10,000 fields. When we run queries, our CPU(only one, running at 300 mhz) Wait, you have a single query that return 10,000 columns? Are you sure that's not 10,000 rows? I know Informix support over 32,000 columns per table, and then there are join results, but that is a bit much! And you wonder why the query runs for 2 minutes and uses all the resources you have? Please post the SQL for this query and if possible the schema(s) of the table(s) in question. > is busy, close to 98%. Can some one help me figure out why it is taxing the > system so much and how to speed up query time? Right now, only one person > at a time is running the queries and if the second person tries to run a > query, it takes about 4 min. for the query to be done. One thing you can certainly do is turn off PDQ by setting PDQPRIORITY to zero (set MAXPDQPRIORITY 0 in the onconfig file to prevent smart users from increasing it). > Please excuse me if I did not give enough data to help answer the problem, > as I am Intern and I am learning as I go along. > > Thank you in advance and for your time, > Raj. Art S. Kagel