Hello,
I'm using the MySQLDirect.NET for the Compact Framework in a new smart device application. The program will act as an update utility for the devices and polls the MySQL DB periodically (every 12 hours) for new updates. The rows returned from the DB will be around 10-30(50 max). The number of clients will eventually be in the millions (polling at different intervals). The server setup is a Linux cluster of MySQL servers.
My question is what kind of performance is this going to give? It's a loaded question, but what I'm really looking for is... Is this the right way to accomplish my goal?
Any help is appreciated.
Thanks.