I have a script I managed to put together - what this does is pulls Affiliate data, matches it with the Customer, Order total and Order date - the issue is that even now the API is pretty slow and my concern over the long term as this grows is the time it will take to search all the records. Given we will end up with thousands of orders and possibly dozens of distributors, I see where this could be a long term issue......

http://mltinnovations.info/assetnatural/dev/test.php

So what I am thinking is trying to figure out or FIND OUT if it is possible to call to the API and only show the 10 most recent orders?? 

This would be adequate I think for the distributors and would lessen system load going forward as well... The issue I see is the way the API is limited to only date, orderID or entity... I might also add as a wishlist item to the devs - please add an API to the affiliate program if possible in future releases, as well an API that cross references name, orders, etc in one API.. right now im pulling the data from 2 seperate operations but I could see where it would be much easier if the data was available just a tad bit different :-)

And 2nd item - IS there a way to do this LOCALLY on the BC server without parsing out using PHP or .Net off server?  and if NOT, what is the best "recommended" method for pulling this data BACK into BC into a secured area so when USER A logs into - USER A only sees HER orders... right now my test above is hardcoding the "distributors name" into it for lack of being sure of another way to do it and return the data to BC, e.g. via webapp or secured page....

Thanks in advance, Hope this makes sense what I am asking,

Tom Cuneo