Hi, I'm sorry, I don't understand. What is the problem?
> 'Native fulltext index' was changed. Do you mean, you use now "Native fulltext search" instead of "Lucene fulltext search"? > But 'delete clob' slow. > So many row to delete at once, rather than > Speed was improved by removing one per row. > (Still not fast enough.) Is deleting a CLOB slow? How slow is it exactly, and how slow do you expect it to be? You wrote it is faster if you delete one row at a time? How much faster is it? > I 'CALL FT_CREATE_INDEX' bug found. I am sorry, what is the bug? What do you expect to happen, and what happens in your case? > '. h2.db' continue to grow in size. It is normal that the database size grows if you add a fulltext index. The database size does not shrink when you remove data, but it should shrink when you close the database (after removing data). It may not shrink fully. To shrink it fully, you can either open and close the database a few times, or call SHUTDOWN COMPACT (this may take a long time). > But that worked to kill and re-connect. I don't understand, sorry, Regards, Thomas -- 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.
