Toad World® Forums

generating results from tables with blob columns



When you select * from table with blob column (with large blobs inside) generatng results take a long time, and network has lare consumption. It looks like sqlnav gets blob data to client. I think that blobs should be only identified as blob column, downloading data should be only when you try to edit blobs.

When you select data from table excluding blob columns, sql works as fast as from normal table.

Regards Piter


Yes, this would be a good performance improvemnt Piter!!
I’ll log a CR and we’ll look at it with the other performance issues that we will be tackling post 5.5…
Thanks for the suggestion…