The doctor works exclusively in the SQL app with their own login and performs all relevant examination steps. Once the patient arrives, the technicians have to 'sync' the patient data to SQL and bring it all up for the doctor to review. The basic workflow is that patients are entered and scheduled in the older FMP11 app, and front-line interaction data with them is collected there. This design was a stop-gap the vendor put in to work around changes in medical laws that would have otherwise rendered their product unusable. It needs to be rebooted periodically to get SQL to release RAM or it would eventually consume the 48GB available on the server and performance *really* tanks then.Ī major flaw in the design for this app is that the SQL portion is an "add on" to an older FileMakerPro 11 app (hosted on a different server, with database files upwards of 1.5GB for some tables) that drives the initial data collection and final data processing - SQL is used to handle all the transactions in between and collects data from FileMakerPro and pushes it back when the patient encounter is complete.
When the server boots up and the SQL process starts in around 3GB of the available memory and keeps growing. The application is a medical app, used by doctors and technicians to record patient interactions and all other related data. The entire database is approximately 22GB, with just under 550 tables. The SQL server is 64-bit Windows Server 2008 R2 running SQL 2008 with 48GB of assigned RAM.
I feel like I have at least a rough understanding of what it can do, and what it should be able to do. I am by no means a SQL expert - I can install it and add a few empty tables, and have worked around programmers before using it. Upper management hears this, but repeats that they are not moving and are locked into a contract they don't want to break. Nothing gets better, user experience with the app is terrible, and everyone is extremely fed up. My predecessors also fought with the vendor on a pretty regular basis over the same things. I've been in my current job for 6 months now, and have been fighting with our software vendor over the performance of our core app for the duration of that time.
0 kommentar(er)
