Forum OpenACS Q&A: Re: Augmenting acs_objects - Add package_id, name, overview, etc. to it

Okay, so assume you add a name column to acs_objects. Have you calculated the time required to update the name, or any other field in that table? it is very very slow. Probably that won't change too much, but how about the description field? I would guess that acs_object.name scales fairly well with the number of rows in acs_objects, whereas putting changeable data into that table doesn't scale at all.

Poorly designed interfaces that select hundreds, or thousands of rows of data, of any possible object type, should be changed to work nicely.

I also find it difficult to imagine an application where you would search for an object by name by using acs_object.name. The data exists in a separate table that the application should know about.