Mario Ruiz wrote: > Hi Peter, > Many thanks for your email, I do appreciate your comments, and no > worries, no offence taken from your email. I also would like to thank > the other members of the forum for their questions and feedback. > > Insight is reasonably fast, for example while searching the patients > tables, takes around 3-5 seconds to find a single match on a 10,000 > patients database, when performing crytographic operations and various > transformations is usually quite fast ( don't have numbers). > I am not familiar with Practsoft performance but I understand that their > hardware requirements are quite high end. You can run Insight on a > 800Mhz PII with 500Mb of Ram in the back office with no sweat, we > believe that lean is better and more stable, less to go wrong and less > to spend. > On the topic of MD demographics, I would be very interested in having a > look at that perl code you have, it would be of great help if you can > shoot me a copy. Also if you have anything on how MD does the writing > back to its DBF file, the file locking and row level locking mechanism > (if any), it would be great. > > Let me have a look at what we can do on the MD front, we might be able > to do some fastdev. > Will speak soon, > > Mario.
Mario, the first thing you need to conquer is getting your new and changed patient demographic data into MD. The attached perl code reads from a patient demographic system (this one was Millenium, an American product using DBF files) and spits out a patients.in file, which is imported by MD or HCN's link file processor, containing the demographic details of any patient changed in the last 90 seconds. Of course you won't need to go to that much trouble. The patients.in format is documented in full in MDW2's help file, as is the patients.out format for transfer of data from MDW back to the front desk. AFAIK there is no row level locking in MDW2, only a file system lock on the database file as it is written to. MDW3 will row lock in standard MSSQL fashion, I assume. Hope this helps. Peter Machell.
MDW_Trans.pl
Description: Perl program
_______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
