Find solution
how to integrate bi reports in my web application?

How big should be a dedicated webserver and database with around 5000000 customer records and their financial records for an online payment application? I need exact specification of server and database. How much the webserver and database would cost?

  • I am thinking of developing and on line payment application for a particular business. The business idea is briefly following - There are multiple companies which provides a particular service, say Service A to their customers. Each of these companies has thousands of customers. Now the customers have to pay their monthly bills to the service availed through any of these service providers/companies. I want to give the customer to login into a website, select their service/provide and make online (credit/debit/net banking) payment to these companies. The application has to integrate with a payment gateway for that. The application will provide the reciept on the successfull transaction of the payment. A failed transaction has to return the monwy back to the customer. Also i want to generate monthly customer, revenue and financial reports and give it to the companies so they know how many customers paid what amount during the month. In short it's like any other online payment application which will be accessed by thousands of people to make their payments to various hundreds of companies. It needs to have a dedicated server and database. Suppose I need to have records of arounf 500000 people spread across multiple tables (customer tables, financial tables, history tables etc), how large should be my server size and database size residing on the server. And the most important thing how much the server and database would cost. Since its a web based application i am looking for a webserver and its related oracle databse.

  • Answer:

    If you need exact specs you may want to engage some paid help, but this size application is likely going to need fairly serious hardware. Consider hosting it in the cloud so you can scale it as your business grows.

Larry Pieniazek at Quora Visit the source

Was this solution helpful to you?

Other answers

IF (and this is a big if) 100,000 customers paid an average of 1 bill through your system every month, once a month, that would 3,333 per day (approx) if they only did it during a 15 hour period of the day that is 222 per hour, 38 per minute, or just under two seconds per transaction. I think that could be handled on the original IBM pc and you could still play space invaders. If you scale it to each paying 4 bills, you now would be at 1/2 second still well within the realm of a very low end processor on a laptop in battery conserve mode. Scale again to a million users every month and I think the average desktop pc could multitask that and do your word processing and websurfing.   I'm just spit balling here,  any computer engineer types that can adjust my numbers to be more accurate? Your limiting factor will be user access. Bandwidth and interface servers. Any service provider that can assure you of clear access for concurrent feeds of a million will more than handle whatever your model could scale to.

Rick Fritzler

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.