Thanks for the input. I have since given up on the concept of reading from MySQL and instead are just reading from Textfiles. Its certainly not a limitation of MySQL or capability issue as the system can handle many reads per second. In fact, the system is currently executing a REPLACE statement (not especially efficient either) for EVERY tick for 22 Forex symbols, so you can imagine how many queries are being executed at a time during busy periods. It does that flawlessly (as far as I can tell at least).
Oh well. Reading from a Textfile isn't ideal, but it works. If anyone finds a reliable means to read from MySQL, please add a note as I'd still be interested.
To add comments, please log in or register