I seek advice on the following question................................
I write java programs (strategies) to place orders on a forex market platform
My current setup :-
The program is about 2,000 lines long and references two access tables using JDBC Part of the program is housekeeping re the platform but the bulk is the strategy programming
I connect to the platform and run the java program on my sole computer
A proposed different setup:-
ms.NET framework(.NET 4.5, WPF c#) and runtime using MS SQL server 2017 running on a network of four computers
The four computers are used to run four different database table configurations
I have no experience on this proposed setup !!!
I am assuming that under this proposed setup all the calculations are done on inhouse computers and that
one connects to the forex platform solely to place an order
A completely different setup to what I am currently running
My question is : should I consider attempting to implement the proposed setup
i.e. what are the pros and cons ?
Thank you for your interest..................
The complete setup uses pattern recognition and this involves using a grid of a certain size
Currently I am using only one sized grid but the idea is to use four different sized grids
Thus the main program will be running on four different computers, accessing a couple of tables (which are different in each of the four instances)
Each version of the program will be similar in many respects except for the differences that the different grid size dictates
each of the 4 instances has two database tables
1) has about 33,000 records - each record has about 30 fields
2) has about 2,500 records - each record has about 12 fields
IO or CPU bound - unclear what that means ???
Currently I have no limitations but if I wished to stay with one computer then wouldn't I have to run my main program four times, one after the other, to accomodate the four grid sizes
whereas with four computers the four instances of the main program could run simultaneously
Got it. So the idea is to have four local databases instead of one.
I think you are going to need to look at bandwidth use for the database. It might be easier to have one database that all four grids reference. Or it might be easy to keep the views in sync and be a moot point.