Author Topic: getOrdersPerCustomer method very slow  (Read 39 times)

giacomokk

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
getOrdersPerCustomer method very slow
« on: November 28, 2017, 10:34:43 AM »
Hi, i'm trying to get all orders for the logged in customer using kk web services in this way:

KKWSEngIf eng = new KKWSEngIfServiceLocator().getKKWebServiceEng();
eng.getOrdersPerCustomer(<params>);

it works, but i see that is very slow for acquiring a list of 50 orders, it takes about ten seconds!

I'm using konakart 8.5.0.0.

Can you help me?

Thanks.

Giacomo




julie

  • Administrator
  • Hero Member
  • *****
  • Posts: 535
    • View Profile
    • KonaKart
Re: getOrdersPerCustomer method very slow
« Reply #1 on: November 29, 2017, 06:47:21 AM »
I would analyze whats taking up the time. i.e. Database, code or transmission of results.

giacomokk

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: getOrdersPerCustomer method very slow
« Reply #2 on: December 06, 2017, 05:26:31 AM »
Hi Julie, do you have news?

Thanks.

G

julie

  • Administrator
  • Hero Member
  • *****
  • Posts: 535
    • View Profile
    • KonaKart
Re: getOrdersPerCustomer method very slow
« Reply #3 on: December 06, 2017, 06:36:24 AM »
Not really. As I said you need to do some work to see where the time is being spent. I'd start by seeing how long the DB is taking to return the data.