Loading to Sybase is very slow

sureshchandra · Post by **sureshchandra** » Tue Jul 17, 2007 10:53 pm

Hi,
I am trying to insert 5,00,000 records from sql server to sybase
using odbc stage. the performance is very bad- 5 rows/sec. Any inputs.

Thanks in advance

ArndW · Post by **ArndW** » Wed Jul 18, 2007 12:56 am

Suresh - without providing a lot more information nobody is going to be able to help you. How do you know that the load is the slow part, it could be the read from SQL Server or the transformation. Instead of writing to Sybase in your job, output to a sequential file stage and a file in C:\nul and see what your speeds are.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 18, 2007 2:44 pm

Sure it's slow - update always is, particularly if there are indexes and constraints.

Why not use bulk loader?

kcbland · Post by **kcbland** » Thu Jul 19, 2007 7:43 am

FYI, a simple empty table with no indexes or triggers, etc, SYBASE IQ is pathetic to load using ODBC/OCI. The only viable option for performant loading in IQ is command line (LOAD TABLE from file).

turash · Post by **turash** » Fri Aug 10, 2007 3:00 pm

you can use Sybase BCP load stage

[quote="sureshchandra"]Hi,
I am trying to insert 5,00,000 records from sql server to sybase
using odbc stage. the performance is very bad- 5 rows/sec. Any inputs.

Thanks in advance[/quote]

DSXchange

Loading to Sybase is very slow

Loading to Sybase is very slow

Re: Loading to Sybase is very slow