> 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
>

The better way to is not to do it!
Store the file outside the db and store a reference to it in the db - a lot
faster.
Think also of how long it will take to backup and restore such a database.

Alan