Topic
  • 5 replies
  • Latest Post - ‏2012-11-15T09:20:34Z by cglockner
GoodGulf
GoodGulf
610 Posts

Pinned topic CQ API login to remote (USA to India) database takes forever

‏2012-11-14T17:43:08Z |
It seems that logging in from the US to a remote database in India via a script takes 15 minutes just to log in.

This is over a dedicated MPLS connection.
Ping times to the server run between 180-200ms.

We're using CQ 7.0.1.12 with Oracle as the underlying database.
I can log into a local database in under 2 seconds.
If I log into a machine over there and log in via the script, I get the same 2 second (or so) login time.

When I configure a dbset here in the US to connect to the India databases, I end up with a 15 minute wait just to log in.
After the log in, transaction times are just as they would be with a local database.

Normally, I would just log in over there and do whatever but I can't in this case.

Is this a normal connect time or should I be looking for something else?
As I said, I don't think network latency is the issue.

Anyone have any suggestions on what might be going on here?
Updated on 2012-11-15T09:20:34Z at 2012-11-15T09:20:34Z by cglockner
  • martina
    martina
    195 Posts

    Re: CQ API login to remote (USA to India) database takes forever

    ‏2012-11-14T18:51:17Z  
    that's a "feature" and that's why there is cqweb.
    Since you say that you are on 7.0.1, you are pretty much stuck.
    If its just a script doing whatever, just let it run. If it is time sensitive, especially with end users involved you may want to look for other solutions of somehow getting your script to run local to the db.

    f.y.i.
    cqweb also has some scripting capabilities via the OSLC rest api. I have not kept up with how full featured is has become recently. It is definitely not the full api.

    hth

    Martina Don't Postpone Joy - Have Fun
  • GoodGulf
    GoodGulf
    610 Posts

    Re: CQ API login to remote (USA to India) database takes forever

    ‏2012-11-14T19:13:58Z  
    • martina
    • ‏2012-11-14T18:51:17Z
    that's a "feature" and that's why there is cqweb.
    Since you say that you are on 7.0.1, you are pretty much stuck.
    If its just a script doing whatever, just let it run. If it is time sensitive, especially with end users involved you may want to look for other solutions of somehow getting your script to run local to the db.

    f.y.i.
    cqweb also has some scripting capabilities via the OSLC rest api. I have not kept up with how full featured is has become recently. It is definitely not the full api.

    hth

    Martina Don't Postpone Joy - Have Fun
    Martina,

    Just so I have this straight, you're telling me this is inherent to the product?
    That a 15 minute login is normal?
    30 seconds I can see but what could possibly take 15 minutes?
    Is it sending out for pizza or something?
  • GoodGulf
    GoodGulf
    610 Posts

    Re: CQ API login to remote (USA to India) database takes forever

    ‏2012-11-14T19:16:17Z  
    • martina
    • ‏2012-11-14T18:51:17Z
    that's a "feature" and that's why there is cqweb.
    Since you say that you are on 7.0.1, you are pretty much stuck.
    If its just a script doing whatever, just let it run. If it is time sensitive, especially with end users involved you may want to look for other solutions of somehow getting your script to run local to the db.

    f.y.i.
    cqweb also has some scripting capabilities via the OSLC rest api. I have not kept up with how full featured is has become recently. It is definitely not the full api.

    hth

    Martina Don't Postpone Joy - Have Fun
    We will be upgrading to 8.0 soon.
    Trust me, I am fully aware of the 8.0 web's OSLC capabilities.
    Sorry, I'm still a little shell shocked over the 15 minutes. ;-)
  • martina
    martina
    195 Posts

    Re: CQ API login to remote (USA to India) database takes forever

    ‏2012-11-14T20:42:06Z  
    • GoodGulf
    • ‏2012-11-14T19:13:58Z
    Martina,

    Just so I have this straight, you're telling me this is inherent to the product?
    That a 15 minute login is normal?
    30 seconds I can see but what could possibly take 15 minutes?
    Is it sending out for pizza or something?
    Denver to Toronto (or so) logon took around 7 minutes if I remember right. The logon is the slowest op (if I remember right, its been a while since I started my script before I went home and had it do state transitions overnight).

    So 15 minutes to India from the US seems to be not too far off as an extrapolation.

    Martina Don't Postpone Joy - Have Fun
  • cglockner
    cglockner
    345 Posts

    Re: CQ API login to remote (USA to India) database takes forever

    ‏2012-11-15T09:20:34Z  
    • martina
    • ‏2012-11-14T20:42:06Z
    Denver to Toronto (or so) logon took around 7 minutes if I remember right. The logon is the slowest op (if I remember right, its been a while since I started my script before I went home and had it do state transitions overnight).

    So 15 minutes to India from the US seems to be not too far off as an extrapolation.

    Martina Don't Postpone Joy - Have Fun
    SQL transactions never work well over high-latency connections, and there are quite a few queries run during login.

    -Christian