Page 1 of 2 12 LastLast
Results 1 to 10 of 16
  1. #1
    Join Date
    Dec 2014
    Posts
    260

    Default PayKonect Question About Time it Takes for Transactions to Load

    Hi Thomas!

    Just wanting to know since you've no doubt tested PayKonect already several times yourself, if you could tell me what determines the speed of loading the transactions:

    1. Amount of transactions? My guess would be this would be the most important. So let's say I pull down a year worth of transactions, and there are 1000 transactions, and a customer pulls down a year worth of transactions, but he only has 75 transactions, then his would be much faster or just a little faster?

    2. Number of API calls? I know we discussed this before. So if a year of transactions requires 4 api calls to PayPal, does that slow it down dramatically compared to 6 months of transactions and only 2 api calls?

    The reason I'm asking is just for a future user guide for the customer, to give the customer an idea about what to expect, based on number of transactions or number of api calls, or both (or more in addition to those two things [?]).

    Right now we're trying a little over a year of transactions, and I'm guessing there will be at least 1000 total transactions. It's been an hour so far and still waiting on it (but I have it running on the remote server and viewing it in the background as I work on something else). I'll let you know when the transactions load or if something else happens.

    Thanks Thomas!

    Mel

  2. #2
    Join Date
    Dec 2008
    Posts
    3,225

    Default

    Quote Originally Posted by Mel Bel View Post
    Hi Thomas!

    Just wanting to know since you've no doubt tested PayKonect already several times yourself, if you could tell me what determines the speed of loading the transactions:

    1. Amount of transactions? My guess would be this would be the most important. So let's say I pull down a year worth of transactions, and there are 1000 transactions, and a customer pulls down a year worth of transactions, but he only has 75 transactions, then his would be much faster or just a little faster?

    2. Number of API calls? I know we discussed this before. So if a year of transactions requires 4 api calls to PayPal, does that slow it down dramatically compared to 6 months of transactions and only 2 api calls?

    The reason I'm asking is just for a future user guide for the customer, to give the customer an idea about what to expect, based on number of transactions or number of api calls, or both (or more in addition to those two things [?]).

    Right now we're trying a little over a year of transactions, and I'm guessing there will be at least 1000 total transactions. It's been an hour so far and still waiting on it (but I have it running on the remote server and viewing it in the background as I work on something else). I'll let you know when the transactions load or if something else happens.

    Thanks Thomas!

    Mel
    The newer api allows you to bring back more transactions but it keeps you within (I think) 3 month increments. So if the user is searching more than 3 months, like a year, I have to do it all in the background. That would be 4 api calls. The user won't have to worry about it since I am doing everything necessary to pull down the whole year.

    The user won't know what is happening. It is being done in the background and there will be a status showing PayKonect is syncing transactions. Once the syncing is done it will pop up an alert telling the user it is done.

    I just looked it up and the max is 500 transactions per call. That means if you have over 500 transactions within that 3 month time frame it needs to call the API more times to retrieve all those transactions just for that time frame.

    Then it will take a lot of time to save all the data since it gathers the data from paypal first and saves it to the database. 1,000s of records being saved at once is a pretty big task. Maybe I need to break up it up and save it in chunks.

    An hour seems too long for it to run. I would advise against doing a whole year of transactions, but great way to test.



    Thomas

  3. #3
    Join Date
    Dec 2008
    Posts
    3,225

    Default

    I'm starting to think I need to set a date range limit of 3 months so the user can't search for a year or two years.



    Thomas

  4. #4
    Join Date
    Dec 2014
    Posts
    260

    Default

    Yes, it's been over 2 hours now and still nothing, so I'm going to shut it down and then try just a few months.

    Thanks!

    Mel

  5. #5
    Join Date
    Dec 2014
    Posts
    260

    Default

    Quote Originally Posted by TigerSoftware View Post
    I'm starting to think I need to set a date range limit of 3 months so the user can't search for a year or two years.



    Thomas
    Setting a 3 month limit sounds good.

    Mel

  6. #6
    Join Date
    Dec 2008
    Posts
    3,225

    Default

    Quote Originally Posted by Mel Bel View Post
    Setting a 3 month limit sounds good.

    Mel

    Yeah, and I will do some tweaking to how it saves the records.

    Thanks!


    Thomas

  7. #7
    Join Date
    Dec 2014
    Posts
    260

    Default

    Thomas, so far I am unable to load any transactions successfully. I've tried on both the remote desktop server and my home computer, tried with just a week of transactions, and with "General" type of transactions chosen. Ran each time for over 15 minutes.

    Let me know if it needs to run longer for only a week of transactions and I'll let it go longer.

    I also opened Task Manager, and it shows PayKonect using memory but no CPU usage at all.

    I'm going to sleep, but I'll give it a go tomorrow sometime also after I wake up.

    I followed all of the instructions to the letter. Authorization succeeds each time, so I'm guessing my credentials and everything is correct. If you have some suggestions of what else to check, let me know.

    Thanks!

    Mel

  8. #8
    Join Date
    Dec 2008
    Posts
    3,225

    Default

    It looks like a permissions issue with Paypal. I'm getting a permission error on my live account. Strange since it worked on the sandbox account.

    Did I mention how much I hated Paypal?


    Thomas

  9. #9
    Join Date
    Dec 2008
    Location
    Blue Planet
    Posts
    909

    Default

    Quote Originally Posted by TigerSoftware View Post
    It looks like a permissions issue with PayPal. I'm getting a permission error on my live account. Strange since it worked on the sandbox account.

    Did I mention how much I hated PayPal?


    Thomas
    Yeah, ya did....but don't let me stop you hating em...i do too. They're a money hungry company and they took 3 weeks to FIX the issue i had (and hundreds of others)
    with the sandbox simulator...it was frustrating...could not test (not needed a real test as i have never had an issue with live....yet :/ )

    But....i am getting same as Mel. authenticates fine...but no transactions.
    While waiting i will try a sandbox test with it

    Robbie

  10. #10
    Join Date
    Dec 2008
    Posts
    3,225

    Default

    Quote Originally Posted by schmutly View Post
    Yeah, ya did....but don't let me stop you hating em...i do too. They're a money hungry company and they took 3 weeks to FIX the issue i had (and hundreds of others)
    with the sandbox simulator...it was frustrating...could not test (not needed a real test as i have never had an issue with live....yet :/ )

    But....i am getting same as Mel. authenticates fine...but no transactions.
    While waiting i will try a sandbox test with it

    Robbie
    I posted a question on the forum. Will wait to see if anyone has had the same issue.

    You won't be able to test with the sandbox as it needs a different url. The sandbox is working fine for me.


    Thomas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may edit your posts
  •