• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Ron McLeod
  • Tim Moores
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Vijitha Kumara

advice sought on Database Management Systems  RSS feed

 
Ranch Hand
Posts: 190
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
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 ?

Bob M
 
author & internet detective
Posts: 39206
726
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Bob Matthews wrote:The four computers are used to run four different database table configurations


I don't understand this. Are you saying to separate tables across four computers? That seems unnecessary.

Things to think about: how much data will you have in the database? is this program IO or CPU bound? What limitations do you hit on a single computer? How many users will you have?
 
Bob Matthews
Ranch Hand
Posts: 190
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Jeanne
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

Data:-
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

Only one user - me
Many thanks

Bob M
 
Jeanne Boyarsky
author & internet detective
Posts: 39206
726
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
He repaced his skull with glass. So you can see his brain. Kinda like this tiny ad:
global solutions you can do in your home or backyard
https://coderanch.com/t/708587/global-solutions-home-backyard
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!