[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] My Simple Brain - Data Storage - FH+Habits
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] My Simple Brain - Data Storage - FH+Habits |
Date: |
Fri, 26 Nov 2004 10:52:28 +0100 |
User-agent: |
Mutt/1.3.22.1i |
> > Why is having clinical data in multiple separate tables a problem. Surely
> > that
> It's not, we do have separate tables. We *also* have an single ancestor table
> which allows us to search across all the clinical tables at once. (This
> concept does not exist in MS-Access)
Ah, well put ! That does make things clearer.
> Sure we could do a massive join across all the tables, but on postgres
> that would be unworkably slow.
Not sure that is true with properly indexed tables - but
surely a bit slower than having the ancestor table.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346