[baseten-users] Understanding relation enabling/disabling

[Tuukka Norri]

Hi!

Jianhua Meng kirjoitti 1.4.2009 kello 19.14:
> What's the rationale for disabling a relation? Is it because of it  
> consumes resource unnecessarily?
Exactly. The space requirement isn't substantial; about 24 bytes plus  
the size of the primary key for each change. These rows also get  
removed within minutes. Each change does trigger some SQL function  
calls, which might take a significant amount of CPU time for very  
frequently updated tables.

> What is the problem with enabling all relations regardless? How  
> should I decide what to enable and disable?  It would help  
> developers if we don't have to deal with the  issue unless there is  
> significant gain in having this kind of control.
In general, you should enable the tables from which you need to fetch  
rows. Enabling tables that don't require it shouldn't cause any  
problems, though, if they don't get changed multiple times each second.
-- 
Best regards,
Tuukka Norri
MK&C