New Posts For Thread: MySQL helphttps://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-helpI'm using c++ builder and Devart MyDAC components to access a MySQL form database called Formbook. I want to have two seperate programmes running.Prog 1 will be retreiving a list of my latest odds from Formbook, placing bets through the API and updatI can't think of any problems DStyle. The two progs will be writing to the same table (although I could make it otherwise) but each will be writing to a separate group of fields with neither group dependent on the other. Thanks for your help.https://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-help?post_id=515511337#515511337I can't think of any problems DStyle. The two progs will be writing to the same table (although I could make it otherwise) but each will be writing to a separate group of fields with neither group dependent on the other. Thanks for your help.Wed, 25 Jan 2012 08:19:19 -0600what i meant, without going into the detail of precisely how your program will work, is if you have two things writing to the same row, you need to think about whether there are any dependencies or not. for example, if prog A writes X to row 1, shoulhttps://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-help?post_id=515510845#515510845what i meant, without going into the detail of precisely how your program will work, is if you have two things writing to the same row, you need to think about whether there are any dependencies or not. for example, if prog A writes X to row 1, shoulWed, 25 Jan 2012 08:06:10 -0600Thanks DStyle. I'm not sure what you mean in your last sentence. The odds aren't going to change by that much and Prog 1 would only be betting where there was room for error in the odds so I wouldn't have a problem with it working with out of date odhttps://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-help?post_id=515510077#515510077Thanks DStyle. I'm not sure what you mean in your last sentence. The odds aren't going to change by that much and Prog 1 would only be betting where there was room for error in the odds so I wouldn't have a problem with it working with out of date odWed, 25 Jan 2012 07:41:13 -0600locking will dealt with by mySQL so your updates from the two different programs will be serialised. readig is obviously not a problem.you probably need to have a think about the impact of concurrent updates though from the data point of view though.https://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-help?post_id=515509819#515509819locking will dealt with by mySQL so your updates from the two different programs will be serialised. readig is obviously not a problem.you probably need to have a think about the impact of concurrent updates though from the data point of view though.Wed, 25 Jan 2012 07:32:41 -0600I'm using c++ builder and Devart MyDAC components to access a MySQL form database called Formbook. I want to have two seperate programmes running.Prog 1 will be retreiving a list of my latest odds from Formbook, placing bets through the API and updathttps://community.betfair.com/general_betting/go/thread/view/94082/28871681/mysql-help?post_id=515508247#515508247I'm using c++ builder and Devart MyDAC components to access a MySQL form database called Formbook. I want to have two seperate programmes running.Prog 1 will be retreiving a list of my latest odds from Formbook, placing bets through the API and updatWed, 25 Jan 2012 06:35:15 -0600