Further testing (over subsequent days) shows that moving the field position of the BLOB fields to the bottom of the list (highest index number) makes no difference in performance. The second table (with BLOBs) is still executed much slower than the table without the BLOBs.
- [firebird-support] SELECT statement runs at different spee... red_october2009
- Re: [firebird-support] SELECT statement runs at diffe... unordained
- [firebird-support] Re: SELECT statement runs at d... red_october2009
- [firebird-support] Re: SELECT statement runs ... red_october2009
