How to speed up import/export features

[lalberti]

Does anybody know a way to speed up import/export features?
Our package is build on 188 .dll files and it takes about an hour to import/export.
Why this poor performance?

Target server: Compaq Proliant 1600/866Mhz, 768Mb, WIN NT SVR 4.0/MTS.

Thanks in advance for help...

Luca
RAMCube S.r.l.
luca.alberti@ramcube.it

 

[chiph]

Luca -

Where is all the time being spent? Is your import/export process CPU bound, Network bound, or I/O bound?

Rule of thumb: Spend 80% of your time optimizing the code that takes 80% of the execution time.

Chip H.

 

[lalberti]

Good suggestion about checking CPU/Network/I-O bound...I'll go to take a look to performance monitor....

Sorry but I don't understand why you're talking about optimizing the code...I'm running an import/export function on a package...that is compiled code...so?

Thanks,

Luca

 

[chiph]

Luca -

But if your compiled code is doing things like checking for duplicates before performing the INSERT or UPDATE statement, that's at least two hits on the database to insert each record. If you can find a way to eliminate one or more of the lookups (caching frequently-used values, etc), you'll be faster.

Chip H.

 

[lalberti]

Sorry but you do not understand my problem.
My problem is not at run-time.
When I'm talking about import/export I refer to MTS server console that allow to install the package.
MTS server takes to much time to import/export the package.

Hope this help to understand.

Luca

 

[chiph]

Luca -

Now I get it.

Sorry, I don't know of a way to speed up the registering/unregistering of new packages in the MTS console.

Chip H.

 

[Guest_imported]

what kind of utility are u using ?
try avoid doing it try once manually and make atime estimate.
we use installers (windows)which deploy around 100 components in three packages in less than 10 mins
and also export them to the client