According to my own measurements made almost a year ago for the aforementioned data size, BLOB type offers slightly better performance (a few percent) over BINARY. So if you don't need index on this column I'd go with BLOB.
Regards, wburzyns On Apr 4, 1:55 pm, Noel Grandin <[email protected]> wrote: > On 2012-04-04 12:33, Carl Hasselskog wrote:> I have two questions regarding > binary data: > > > 1. I have a column that will contain approx. 1KB-5Kb per row. What is > > generally the best option here, blob or binary? > > binary > > > 1. If I use blob, will the data be read from disk if I include the > > column in my query but don't read from the binary stream in the > > ResultSet? > > no. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
