MS-Sql server - Only Data Loading taking lot of time on WAN

[Ashish Vijaywargiya]

Hello,

I tried setting up ofbiz on MS-Sql server and it worked well on LAN and
WAN. I noticed that data loading is taking too much time on WAN. I am
saying data loading because tables, indexes etc. are getting created too
quickly but this is not the case with data loading process.

Ant command used on LAN and WAN:
ant clean && ant run-install-readers -Ddata-readers=seed,seed-initial

Total Build time on LAN:
BUILD SUCCESSFUL
Total time: 5 minutes 30 seconds

Total Build time on WAN:
BUILD SUCCESSFUL
Total time: 83 minutes 20 seconds

MS-Sql jdbc driver(
http://www.microsoft.com/en-us/download/details.aspx?id=11774):
sqljdbc4.jar

OFBiz Source code: I am using Release11.04
ashish@ashish-laptop:~/ofbiz_dev/testing$ svn info
Path: .
URL: https://svn.apache.org/repos/asf/ofbiz/branches/release11.04
Repository Root: https://svn.apache.org/repos/asf
Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68
Revision: 1385013
Node Kind: directory
Schedule: normal
Last Changed Author: ashish
Last Changed Rev: 1385010
Last Changed Date: 2012-09-15 09:58:42 +0530 (Sat, 15 Sep 2012)

On WAN we have two machines(Both the machines are placed in USA with high
speed internet connection) in which one is having OFBiz source code and
another machine is having MS-Sql server installed on it.
I am sharing some results here so that if any of you came across the same
results on WAN and you got to know about some configuration settings that
needs to be done on MS-Sql side then please comment:


[java] 2012-11-28 11:22:17,745 (main) [    EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/home/ashish/ofbiz_dev/testing/framework/common/data/CountryCodeData.xml
[java] 2012-11-28 11:22:17,746 (main) [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-11-28 11:27:43,400 (main) [    EntitySaxReader.java:289:INFO ]
Finished 724 values from
file:/home/ashish/ofbiz_dev/testing/framework/common/data/CountryCodeData.xml

Total time taken in loading 724 records = Around 5 minutes.

[java] 2012-11-28 11:28:54,213 (main) [    EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/home/ashish/ofbiz_dev/testing/framework/common/data/GeoData.xml
[java] 2012-11-28 11:28:54,214 (main) [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-11-28 11:30:13,140 (main) [    EntitySaxReader.java:289:INFO ]
Finished 279 values from
file:/home/ashish/ofbiz_dev/testing/framework/common/data/GeoData.xml

Total time taken in loading 279 records = More then 1 minutes.

[java] 2012-11-28 11:33:11,852 (main) [    EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/home/ashish/ofbiz_dev/testing/framework/common/data/GeoData_FR.xml
[java] 2012-11-28 11:33:11,853 (main) [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-11-28 11:36:29,204 (main) [    EntitySaxReader.java:289:INFO ]
Finished 451 values from
file:/home/ashish/ofbiz_dev/testing/framework/common/data/GeoData_FR.xml

Total time taken in loading 451 records = Around 3 minutes.

[java] 2012-11-28 11:40:03,265 (main) [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-11-28 11:41:05,222 (main) [    EntitySaxReader.java:289:INFO ]
Finished 240 values from
file:/home/ashish/ofbiz_dev/testing/framework/common/data/GeoData_US.xml

Total time taken in loading 240 records = More then 1 minutes.

[java] 2012-11-28 11:41:34,597 (main) [    EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/home/ashish/ofbiz_dev/testing/framework/common/data/LanguageData.xml
[java] 2012-11-28 11:41:34,598 (main) [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-11-28 11:45:02,727 (main) [    EntitySaxReader.java:289:INFO ]
Finished 433 values from
file:/home/ashish/ofbiz_dev/testing/framework/common/data/LanguageData.xml

Total time taken in loading 279 records = Around 4 minutes.

Thanks!

--
Kind Regards
Ashish Vijaywargiya