Horst Herb wrote:
>
> Nice work, Tim.
Thanks.
> A few questions, though:
>
> 1.) Our practice is small, yet we have some 13.000 patients in our files,
> some 7.000 of them active. How does your system handle this?
>
> 2.) A typical drug formulary nowadays consists in some 10.000 - 30.000
> entries. Same question
This was one of my biggest concerns when considering going from
PostgreSQL to using just the ZODB3 engine with a FileStorage. I
investigated to find out where the wall was. So far it was the
file system limit of 2GB which Linux kernel 2.4 solved (as well
as ReiserFS). I found by reviewing case studies of Zope taht it
handles some pretty large sites (US Navy documentaion for one).
I have tested the robustness of the system as far as handling
large (relatively I guess) numbers of objects by first installing
15,000+ ICD9's. No problem. Then I tested by installing the
Multum drug database (90,000+ drugs as described on the
openhealth list recently). The actual import was a pain. Python
wanted to run away with the memory (may have well been my Python
code that caused it too). :-( But once they were imported it ran
just fine. As with any HTML rendering you want to be selective
about how large a page you want displayed. But the backend system
is not affected by large datasets. The Achilles Heel with the
ZODB storage manager is that it is optimized for many reads/few
writes. So it would not be useful in a large order entry
system. But if you look at this implementation you have a
relatively low number of writes per second, even with several
users in a large practice.
> 3.) Looks like cleartext is transmitted between browser and server. Do you
> support SSL or similar?
There is a SSL implementation for ZServer. However, I would
expect that most installations will use ZServer for local
connectivity and run it via ProxyPass behind Apache for SSL for
external connections.
> 4.) How do you preserve and check data integrity?
>
> 5.) How do you handle concurrent and dependent transactions? (keyword ACID)
>
> 6.) How to you intercept, recognize and handle it when one of your Btrees
> gets corrupt?
The way 'I' do it is to reuse proven, trusted open source
compnents. <s> But I will refer you to:
http://www.zope.org/Documentation/Developer/Models/ZODB
to really answer your questions.
Great questions Horst!
Thanks,
--
Tim Cook, President - FreePM,Inc.
http://www.FreePM.com Office: (901) 884-4126
ONLINE DEMO: http://www.freepm.org:8080/FreePM
_______________________________________________
Freepm-discuss mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/freepm-discuss
