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

Yan Yan wrote in message <363DDA76.A3F3A461@hk.gin.net>... >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 What is OPTCOMPIND set to? Often when you go through this type of upgrade you may want to set it to 0 instead of the default of 2. It could be the optimizer has chosen too many hash joins for you table & CPU configuration. Setting it to 0 will encourage using the indexes. There are definitely times to use either 0,1, or 2, but most upgrades from 5 to 7 that I've seen ran faster with OPTCOMPIND as 0 until they laid out their data differently and added more processors. Of course your mileage may vary. :-) S.W.