Re: se to ON-Line database, most of program running become too slowly ! Help/Urgent

Yan Yan wrote: > > Any Helper !, > I just have upgrade from SE to On-Line, I found most of program > running very slow > ( SE use 3 seconds, On-Line need 5-7 minitues),the follow is my > convertion steps: > [a] Dump all data from SE > [c] Generate the create table/index scriptis > [d] Create On-Line database and upload all data into > [e] run the stats for all tables(I know it can affect the program > use index) > [f] compile all 4gl program > > Note : I debug the program use index from on-line and SE, I found > it can use > the right indexs but plus filter, I have try to change > the sequence of where > clauses or add Optinum High, but It seem does not > change anything. > Do you have any factors can caused that ? > > Best Regards > > Lion Check OPTCOMPIND in your ONCONFIG file. By default in the 7.x versions it will be set to 2. Reset it to 0 and restart Informix. John Carlson Informix DBA WHSmith, Inc.