Submission + - RDBMS for CTI system
cpt_koloth writes: "We(=the company i work for) are currently in the process of designing a custom cti system for a client. A small part of the system is implemented, mostly to familiarize the development team with the telephony api(in our case TSAPI, since the client uses an ericsson PBX) as a simpe click n dial application. The main issue is the database system which will be used. We need a database that needs to be fast in order to be used for assigning the calls without delays. The present system uses Mysql and is doing great but the numbers of requests will increase exponentially once the "main" parts of the system are implemented(we have about 60000 requests per day currently most of them being cross table queries but finaly they should be seven or eight times this number).Another aspect is the reporting agent which will operate on the same database and also needs to be fast. We are currently thinking on a system with two databases one for the "calling part" of the system and one for the reporting part but we cannot decide on neither the RDBMS to be used not the way the data will be updated between the two databases. Keep in mind that cost matters a lot. Any insight would be appreciated"