Hi, I think H2 should be already quite efficient for such data. To verify, you could run a benchmark with the array against your own serialization code (convert the doubles to a byte array and back, and use the binary data type).
Regards, Thomas On Wednesday, May 9, 2012, essence wrote: > Most of the data in my database is stored in a column with an array > data type. Typically it holds 3000 doubles. > > > Has anybody done any investigation into performance with this kind of > database? select query, delete query? > > Where are the bottlenecks? On my initial investion the select > bottleneck was in the .read method. Can't remember which class. > > I'm basically asking how much effort has been expended on tuning this > kind of database. If not a lot, i will investigate, if it has already > been tuned, i will buy a faster box! > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to h2-database@googlegroups.com. > To unsubscribe from this group, send email to > h2-database+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
