×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

How to speed up import/export features

How to speed up import/export features

How to speed up import/export features

(OP)
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

RE: How to speed up import/export features

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.

RE: How to speed up import/export features

(OP)
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

RE: How to speed up import/export features

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.

RE: How to speed up import/export features

(OP)
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

RE: How to speed up import/export features

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.

RE: How to speed up import/export features

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close