On SD Client, I am creating a xml file thorugh sd_export. The xml file size is approximately 50MB. The time taking for importing the file in to service desk is close to 10 hours. My sytem configuration is Intel Pentium 3 Processor with 3.5GB of RAM.
Any idea as how to increase the performance while improting thorough SD Client?
I cannot know how much time you will save by eliminating the client from the processing loop. I do suggest you try it.
There are probably two other areas where you can make a significant difference in import times, depending on what you need to import.
1. If you are simply updating data, rather than creating new rows in the database, your import will probably go much faster.
2. If you can calculate a delta before doing the import, it will probably go much faster.
3. You might be able to save some more time by splitting the import job into independent segements and running each segment on a different server. This suggestion is completely theoretical. I have never tried it. However, in similar applications I have seen significant gains when the work is split amongst multiple (~3) threads.
So, what kind of data are you importing? 50MB sounds like a lot of data to import on a regular basis. If we had some more details, it might be easier to make suggestions.
Please read the data excange guide on paralell import. Using several clients to import the data in parallel can significantly speed up the import process. Parallel import needs client machines and can not be run on the server itself.
If you are using the sd_import from the server\bin, you can increase its java memory allocation like what we do with the server, see the sd_server.bat for example. Note: the sd_import from the client\bin uses jview instead of java. So I don't think you can increase java memory for jview, jyst java. It might increase the performance since you have memory to spare.
I have imported thorugh server and it was taking almost the same time!!
And from client, I have modified the memory allocation on the sd_import.bat to @ECHO OFF cd .. set IMPORT_CMD_LINE_ARGS= :setupArgs if %1a==a goto doneStart set IMPORT_CMD_LINE_ARGS=%IMPORT_CMD_LINE_ARGS% %1 shift goto setupArgs :doneStart java -XX:MaxNewSize=688M -XX:NewSize=1360M -Xms1392M -Xmx1392M -cp lib\hotfix.jar;lib\servicepack.jar;lib\JClark.zip;lib\common.jar;lib\sdcommon.jar;lib\ms_interfaces.jar;lib\import.jar;lib\ui.jar com.hp.ifc.ext.imp.ImportXmlCim %IMPORT_CMD_LINE_ARGS% cd bin
And this was also taking the same amount of time. If I try to increase the memory allocation it was telling error like "Error occurred during initialization of VM Could not reserve enough space for object heap The system cannot find the path specified."
Please suggest what exactly I have to mention for the memory allocation.