Subject | Is Enhancement or drawback ? (it's IBO not bug) |
---|---|
Author | kamen_lai |
Post date | 2002-03-06T04:44:33Z |
It's not IBO bug or problem , just for discussion.
When post changes through tib_query , i can see that all field will
be sent to server. In case i have 100 fields, and 10 is blob ,
when user only change 1 field. The update sql is
'Update tableName Set field1=??? ,.....,f100=??? where ????'
but the user only change 1 field , so other 99 fields is no need to
update.
I know if the editsql dynamic to create & prepare is time consuming
operation , but i want to know is if IBO only update changed field .
instead of all field , is there any benifit ? especially in low band
width environment.
Thanks a lot.
When post changes through tib_query , i can see that all field will
be sent to server. In case i have 100 fields, and 10 is blob ,
when user only change 1 field. The update sql is
'Update tableName Set field1=??? ,.....,f100=??? where ????'
but the user only change 1 field , so other 99 fields is no need to
update.
I know if the editsql dynamic to create & prepare is time consuming
operation , but i want to know is if IBO only update changed field .
instead of all field , is there any benifit ? especially in low band
width environment.
Thanks a lot.