Re: Performance hit on many relationships

From: Xuening Sun <ba503_at_torfree.net>
Date: Wed, 25 Aug 1999 13:17:22 GMT
Message-ID: <FH0vKz.Epz.0.bloor@torfree.net>

Hi, Frank,

From what I understand, you are talking about relationship between referenced table and referencing table. If you enable cascading update on these tables, there could be some slow-down in performance. Having said that, I think you should avoid relating one table to many other tables if you could. But if you have to, creating indexes on foreign key columns for referencing tables would help. If you does not use cascading update, I couldn't see any performance issues.

Xuening Sun
--
Frank Calfo (fcalfo_at_psateam.com) wrote:
: Is there a significant performance hit when updating a table which is
: related to
: 10 -15 other tables?
: Should I avoid relating one table to so many other tables if possible?
-- Received on Wed Aug 25 1999 - 08:17:22 CDT