Re: FW: dbimport slow

Posted in 1997

Harald Ums — Mon, 21 Jul 1997 14:57:33 GMT — source: Informix-list mailing list archive (1991-1998)

SSvolos@ual.com wrote: > >You probably think most of the time is spent loading data, don't you? >It appears this is not true. According to what is displayed on the screen, >over 80% of the time is spent on loading the SPs (stored procedures). > >In addition, the loading speed seems to exponentially decay for each procedure. >In other words, loading a procedure starts out fast, and then slows down >down, and further down. > >Intuitively, it seems that the language parser for SP uses a >back-tracking algorithm >which takes exponential time. However, creating an SP is usually very fast. >So I really don't know why dbimport spends so much time on SP's. > We have similar problems with 7.23.UC1 on Solaris. After interrupting the import the loading of the remeining SPs via dbaccess is fast again. Harald Ums Harald Ums Tel : +49 (0)89-9507-5140 PRO 7 Televisions GmbH Fax : +49 (0)89-9507-5191 Bahnhofstra'e 28 D-80767 Unterf'hring e-mail: Harald.Ums@sevensys.de