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.