Subject | Computed field causing slowdown |
---|---|
Author | Joe Martinez |
Post date | 2004-07-20T18:28:44Z |
I added a computed field to my Firebird table, which is a select into
another table. I added the field to my TIBOTable object with the Fields
Editor, then added a TDBText field to my form to display the value in the
field.
I noticed that now, when I scroll through the records in the table, there
is a noticeable delay going from one record to the next, where the SQL
hourglass appears. For me, it's about 1/4 second, but some of my customers
are reporting a 2-3 second delay.
So, I tried removing the TDBText field from the form, and also removing the
field from the TIBOTable object, but the delay still appears. It seems
that just having the field exist in the Firebird table causes the slowdown.
So, is IBO still somehow pulling that field from Firebird, even though it's
not in the TIBOTable?
Is there any way around this? Can I get my speed back up, without
completely eliminating the computed field from the Firebird table?
I'm using IBO 4.2Gc with BCB 4, Firebird 1.0, dialect 1 database.
Help!
-Joe
another table. I added the field to my TIBOTable object with the Fields
Editor, then added a TDBText field to my form to display the value in the
field.
I noticed that now, when I scroll through the records in the table, there
is a noticeable delay going from one record to the next, where the SQL
hourglass appears. For me, it's about 1/4 second, but some of my customers
are reporting a 2-3 second delay.
So, I tried removing the TDBText field from the form, and also removing the
field from the TIBOTable object, but the delay still appears. It seems
that just having the field exist in the Firebird table causes the slowdown.
So, is IBO still somehow pulling that field from Firebird, even though it's
not in the TIBOTable?
Is there any way around this? Can I get my speed back up, without
completely eliminating the computed field from the Firebird table?
I'm using IBO 4.2Gc with BCB 4, Firebird 1.0, dialect 1 database.
Help!
-Joe