Loading a blob with large meg value files eg > 100 (I need to reach
gig proportions) using the loadFromFile method, results in massive
waits and 0 available CPU, and hung machine
eg

TIB_ColumnBlob(WCursor.FieldByName('BACKUPDATA')).LoadFromFile
(ExtractFilePath(Application.ExeName)+WFileName);

Is there a better way ..this I think tries to load the entire file
into memory first before I fire the WCursor.Post method..
?streaming ? if so help.... I need it to be fast and not hog the cpu

I use the following sql construct

WCursor := TIB_Cursor.Create(Self);
try
WCursor.SQL.Text := 'SELECT * FROM BACKFILE FOR UPDATE';
WCursor.Append;
TIB_ColumnBlob(WCursor.FieldByName('BACKUPDATA')).LoadFromFile
(...etc);
WCursor.Post

etc