|Subject||Re: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing|
> Just to close off this case, the final SQL that SET was looking at is "slow-ish" because it has to make at least 2 hits to the DB (maybe even 4?) because at least 2 of the fields are BLOB SUB_TYPE 1 fields, which I have learned require multiple hits to the DB. Without those fields included in the field list, the query is< 1s.There are two factors here:
> I need to include those fields and the slower response time is tolerable if I explain it to my customer.
1) If the BLOB is small to fit onto the same data page beside other data
of the record, then BLOB data is transfered as any other field data to
2) If the BLOB is too large for the data page, then a pointer to another
page is stored in the field. It then depends on your access components
if it is loaded automatically, even if the user isn't interested in, or
you could delay that e.g. the user needs to click a button a load the
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server