Time require to import different between 7.14 and 7.30

Posted in 1999

Christine Bell — Mon, 04 Oct 1999 10:53:11 -0400 — source: Informix-list mailing list archive (1991-1998)

We have migrated from 7.14 to 7.30 and have found that the time to inport the same database has tripled in time. The time seems to be spent in the stored procedure loading. Has any one else experienced this problem.

↪ replying to Christine Bell

Christian Brauer — Mon, 04 Oct 1999 17:53:16 +0200 — source: Informix-list mailing list archive (1991-1998)

> We have migrated from 7.14 to 7.30 and have found that the time to > inport the same database has tripled in time. The time seems to be spent > in the > stored procedure loading. Has any one else experienced this problem. That's funny, I thought this effect would be unique on my local pc. have the same problem during "create procedure". It's every time the same procedure and my PC (7.30 TC3) hangs for about half an hour instead of a few seconds. Does anyone have an explanation or even a solution for this effect ?

↪ replying to Christian Brauer

Sergey Turin — Tue, 5 Oct 1999 17:34:53 +0400 — source: Informix-list mailing list archive (1991-1998)

Well, dbimport for database with many stored procedures (versions 7.20x and 7.24x for HP-UX) always behaves like that. To speed up SP creation, I have to split foo.sql into 2 parts: 1 for tables/loading/indexes, 2 for stored procedures and triggers. The former one has to be ran via dbaccess after dbimport. I couldn't explain this ( stored procedures cache size ? ) >Does anyone have an explanation or even a solution for this effect ?