big blobs in grid?

Ronald, Can you please clarify what steps you perform in DbVisualizer when you experience this performance issue? When performance is bad, what is the size of the BLOB file? Also, in Tool Properties->General->Grid->Binary/BLOB and CLOB Data, what settings are used for the BLOB/Binary properties? Regards Roger

Hi Ronald, The support for large blob/binary data is currently limited in the table editing feature due to memory issues. We have an open ticket to look into this. There is an alternative for inserting large data and that is to use variables in the SQL Commander: Table being used: create table test_blob (a number, b number, c number, d blob); Inserting large BLOBs is done with: insert into test_blob (a, b, c, d) values (1, 2, 3, ${data||/Users/xxx/out/bigfile||BinaryData||noshow vl=file}$); This will insert the bigfile file in the d column. The following will extract all columns in the table and generate a SQL INSERT file (big.sql). Binary data are exported to individual files: @export on; @export set Filename="/Users/xxx/out/big.sql" Format="sql" BinaryFileDir="/Users/xxx/out" BinaryFormat="File"; select * from test_blob; Regards Roger