A calc field is automatic, and if it is not doing
something complex then it shouldn't affect
performance. For example you could create a table
with the computed by syntax: CREATE TABLE MYTABLE (A
INTEGER, B INTEGER, DIFF COMPUTED BY A-B) This is good
because it is all on the server side and querying the
data automatically returns this field. You can't
alter the data of the computed field though.

If it's doing something that slows down the query alot
then maybe use triggers to update a data field on
relevant update and insert events. One thing that
could slow it down is if your COMPUTED BY expression
is accessing data from other tables to arrive at its
output. If this is the case then the best thing to do
is to try if at all possible to reorganise your tables
to make them normal, access them using joins.

Rob
--- nxciro <pict100@...> wrote:

> Hello
>
> What is the best way to maintain a calculated value
> column
> which is to be displayed in an ib_grid ?
> Should I use a calcfield or is a stored proc
> the better solution ?
>
> nxciro
>
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com