Can anybody give me some advice on database design. If I have to recoed
records of frequent transaction events, am I better to design one indexed
"transaction table" with perhaps thousands of records and foreign keys to
many tables - or would I acheive better performance with several tables of
like transactions. I hope this makes sense. In short is it better to large
tables or more smaller ones.


--
____________________________________________

Eric Wing
Post Grad Finance Assistant
Student Finance Office
University of Bath
Claverton Down
BATH BA2 7AY

Ph: +44 (0)1225 383662
Fx: +44 (0)1225 386317

"Eric Wing" <e.b.wing (AT) bath (DOT) ac.uk> wrote

Performance is very closely tied to the actual DBMS that you use.
There is no answer to your question because there is no information as
to the nature of the types of transactions.

Sorry that's not much help.