Hello. When database reads a row from a table, the whole row is constructed and all its values are read, with exception for large CLOB and BLOB objects. It means that query like SELECT id FROM route2 WHERE name LIKE '%something%' will read a lot of unnecessary data from waypoints column. Not all queries will be affected, if you have a compatible index with all necessary columns, the rows from the table will not be read, but usually very large columns slow down the things.
Please also note that mixed-type arrays such as ARRAY[1, 3.0, TIMESTAMP '2000-01-01 00:00:00'] should be considered as deprecated and may not work any more in the future versions of H2. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/799968dc-4a5c-4f81-b5ba-5dd3109a1e6c%40googlegroups.com.
