gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] Journal performance question


From: James Busser
Subject: [Gnumed-devel] Journal performance question
Date: Tue, 16 Sep 2008 14:37:46 -0700

Over the course of years, a patient could easily accumulate > 1,000 clinical narrative rows among a pool of patient records > 5 million rows.

Would the querying involved in such a build of the patient's Journal cost a lot of time and traffic?

It would seem to me that if the EMR tree (to the level of Issues and Episodes) and Progress notes can be quickly built without requiring that the entirety of clin_narrative having to be queried, would this be any advantage? Or is the table already indexed on the patient unique key so that it makes little difference to fetch only the last 100 or so rows into the Journal unless (perhaps through interaction with the EMR tree) something more is of interest?




reply via email to

[Prev in Thread] Current Thread [Next in Thread]