mercredi 10 août 2016

Best Approach to read data from multiple tables

I have to create an Application to read some live data feed from more than 200 tables simultaneously and process this data. I want to discuss what could be the best approach to solve this problem with optimum speed as for each table we are getting 20+ records in every minute. So far I can think of following solutions :-

1) I can make multiple thread handling some 20 odd symbols independently.

2) I can make two thread one for data read and other for data processing but reader thread will take more time as it has to read all tables sequentially.

my database is MySQL and I am using C++ to solve this problem.I feel that if instead of 200+ tables I can get live data feed in a single table then my second approach will become much appropriate and faster.

Aucun commentaire:

Enregistrer un commentaire