SoloMio,
First, I was trying to help. If you took it any other way, I apologize. You can use all the emoticons you want, but it does not change that your statement was and is rude.
You are completely wrong about how you are seeing things and doing things. In other words, your setup is completely wrong. You CANNOT save a patient to a client computer and not to the server. Can we use the word server to mean main computer. You cannot save anything to the client computer. The only thing that gets saved to the client computer is the spell check information.
You ask how fast it gets to the SQL database. It takes 0.938 seconds on a network set up in a 1GB configuration with adequate processing speed.
Now let me tell you what looks like it is saved on the client. If you write a prescription and close the prescription writer and reopen it, the med will be there. But, it is ON the server not the client. If you send a message to someone or to yourself and save it, it is on the server. Addendums save and may appear to save to the client, but they don't. Nothing other than spell check saves to the client.
But, let's look at the proper way to set up a system and I should warn you that AC support will argue with the server set up. I install to the server, move the databases to the data drive and delete everything else. They would tell you to install to C or D or wherever and leave everything in one folder. I would recommend that to the non-advanced. But, I would never have the AC executable on the server. This means I NEVER open AC on the server. Of course, if you are peer to peer, then you do have to on the main computer if you use it.
Now, when you first install to the server/main computer, you will see a window which says, "IS THIS YOUR MAIN COMPUTER?"
If it is, then you choose the top radio button and, thus, install SQL Server Express. You must have SQL Server installed on the computer you wish to use for the main computer.
Now, when you go to install AC on your clients, you choose the second choice. This choice states that this isn't the main computer and, therefore, there is no need to install SQL Server, there. You simply want the client there and when it opens it will want to find the database on the main computer, and you will browse to it. You will access the databases using the .xml file. You wouldn't be able to connect to the client computer even if you wanted to. So, ALL data (as it should) including new patients and new notes are saved to the SQL databases which are controlled by the SQL Server engines you installed earlier.
NOW.....sure if one were so inclined to install SQL Server on his or her client computer, then yes, you could indeed connect that AC program to the databases on the client. But, then it is obvious that any data saved on that computer would be on that computer and, therefore, not on the main databases available for sharing to all the clients.
I doubt this is the case, but given I have never lost a note in six years (and this doesn't mean I doubt others have), maybe some users have some clients connected to the client computer.
So...in short...when you save a note it goes to the server. When you add a patient, it goes immediately to the server (again if you have your client connected to the server's database). And, you don't have to refresh. Simply backing out of the patient name field will allow you to then enter the new patient and find them on any computer.
I hope this helps. I reread my note from above, and from my perspective, it is nothing but an attempt to help. I really don't know where the attitude comes from. I am just explaining to you how Amazing Charts and its database works in both a client/server and peer-to-peer environment.
