[Top][All Lists]

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

[Gnumed-devel] schema choice

From: syan tan
Subject: [Gnumed-devel] schema choice
Date: Fri, 19 Dec 2003 10:58:36 +1100
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030313

apart from licensing, what do people think of tables that show one "trait" e.g. a person's sex, birthdate , name ,address is a variation of a trait row, and trait row's might be recursive ( e.g. names, ). Is it going too far with the object side of a o-r mapping ? Would it impair the performance a lot ? ( say 10,000 patients x 20 traits, 200,000 rows ; server holds onto a connection and makes a batch of 20 sql retrievals per patient access request from one client).

reply via email to

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