Can you expand on your use case? What is the query selecting on? Is the column you are querying on indexed? Do you really need to look at the entire 20 gb every 20ms? On Jul 14, 2014 6:39 AM, "amjad khan" <[email protected]> wrote:
> I made a storm topoogy where spout was fetching data from mysql using > select query. The select query was fired after every 30 msec but because > the size of the table is more than 20 GB the select query takes more than > 10 sec to execute therefore this is not working. I need to know what are > the possible alternatives for this situation. Kindly reply as soon as > possible. > > Thanks, >
