Skip to Content
avatar image
Former Member

Sybase ASE client installed

Hi

I have installed sybase ASE client in one linux server to extract the data .

i am able to extract but 3 records/second. i have to extract 1 lakhs records from some location. using the same client i am able to extract 100 records per/second.

I can i improve/increase the performance in extracting the data from sybase client?

Please help on this? how can i get

Regards,

Rajendra

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 08:25 PM

    Hi,

    3 records a second sound super slow. This could be many things but I need to make sure I understand the question.
    Okay so you are saying that one ASE is slow and the other is fast with the same client running on a Linux machine?

    In this application is it using bcp?
    Is this application just retrieving one row at a time?
    Are you having to convert charsets? (This can cause a performance issue, are the ASE's both using the same charset? sp_helpsort)
    Are the ASE's the same version? (select @@version)
    It could be the one ASE has a bad plan.

    Is this related to your network? If you do a ping or a tracert to each machine so you can see if it's your network causing the performance issue.

    Thanks,
    Dawn Kim

    Add comment
    10|10000 characters needed characters exceeded