Advise billing API.

Question

Please advise on a solution for the coding below.

Problem:
•  An application for billing 10,000 users over a given billing API (own by a their party e.g ABC/Bank). 
• The billing API takes 1.6sec to process and respond to each request
• The details of the users to bill is stored in a DB with fields
Id,
username,
mobile_number
amount_to_bill

Requirement:
Write or describe a simple PHP code that will be able bill all the 10,000 users within 1hr.

Also suggest an approach to scale the above if you need to bill 100,000 users within 4.5hrs 

Please state all assumption.

Answer 1

It is dependants on your DB architecture,
If require join then use indexing,
Use procedures and functions,
It will more faster than 40% in data searching and fetching records,

Other side optimize your php code, reduce more loops, patches and queries..

For more details you need to share more details about your project, like what type of bills are you generating, what is the flow and fields..