Subject | SELECT BLOB in a view |
---|---|
Author | nikicab_1999 |
Post date | 2005-11-12T04:09:45Z |
If I have a view (MyView) like
SELECT myBlob_id, myBlob from MyTable
and do SELECT * FROM MyView WHERE MyBlob_id=:id
will there be any performance penalty i.e. will FB select all blobs
from MyTable first and then filter it out to give me just one record
OR will it give me the record right away?
Thanks,
Nick
SELECT myBlob_id, myBlob from MyTable
and do SELECT * FROM MyView WHERE MyBlob_id=:id
will there be any performance penalty i.e. will FB select all blobs
from MyTable first and then filter it out to give me just one record
OR will it give me the record right away?
Thanks,
Nick