Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL*XL insert speed test (Read 2615 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL*XL insert speed test
30.10.09 at 17:01:13
 
SQL*XL insert speed test
 
I received questions today about the speed of inserting rows from Excel into Oracle with SQL*XL. I have performed the following test.  
 
Factors that influence the performance
-processor speed
-commit frequency
 
Environment:
I ran the test in a vmware virtual machine. The host is a 2GHz dual core pentium with sufficient memory. I used 550 MB memory for the virtual machine.  
The operating system is windows XP. I used Office 2000. For both no service packs were applied.
Database: Oracle 8.1.7 running inside the same virtual machine.
 
Test:
I loaded data into a table with 134 varchar columns (on average 25 columns contained data). The number of loaded rows is 9880.
 
It took 2:14min to load the data in. Speed 74 rows/sec.
Back to top
 
« Last Edit: 30.10.09 at 17:04:08 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: SQL*XL insert speed test
Reply #1 - 30.10.09 at 18:42:59
 
Quote:
The performance problem actually started when I could not connect with OO4O. I am using 11g client on windows7. I ended up deleting my newly created ADO
connection and created a new one and now it works. It's slow but works.
It take 3-4 hours to upload 9400 records.

 
I have done a performance test (see message above). Please can you run the same test to see what your performance is like?
 
Quote:
Thanx for that test. I just tried it again from another location and it
appears to be network related.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1