Hi,
'Native fulltext index' was changed.
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.)
I 'CALL FT_CREATE_INDEX' bug found.
Or my instructions are wrong.
'delete Lucene index
(1)drop alias FTL_INIT;
(2)CALL FTL_DROP_ALL();
'create Native index
(3)CREATE ALIAS IF NOT EXISTS FT_INIT FOR
"org.h2.fulltext.FullText.init";
(4)CALL FT_INIT();
(5)CALL FT_CREATE_INDEX('PUBLIC', 'WML_MAIL_BODY', 'WMB_BODY');
*WMB_BODY is CLOB.
'. h2.db' continue to grow in size.
But that worked to kill and re-connect.
Thanks.
On 5月1日, 午前1:17, Thomas Mueller <[email protected]> wrote:
> Hi,
>
> In version 1.2.134, there is a new experimental LOB storage mechanism.
> To use it, set the system property "h2.lobInDatabase" to "true".
> Please do not use it in version 1.2.133 however. Could you try if the
> problem is solved if you use this option? I don't suggest to use it
> for production, but it might work. See
> also:http://www.h2database.com/html/changelog.html
>
> Maybe the problem is caused by Apache Lucene however. In this case I'm
> afraid there is little I can do. Did you try to use the 'native'
> fulltext index?
>
> 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
> athttp://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 [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.
