Thunderstone Support Forums

Hi,

I am trying to create a metamorph inverted index on one of my tables. The table size is huge with 2.7 million records. The index creation is taking a long time.

create metamorph inverted index xdocum on Help (Tide\desc\kewo\Bod,Visi,Comm,int_flg,Prd,Rstlag,Dod,Docpe,Quay);

Can you please let us know how we can make the index creation faster. I have to recreate the index.

Thanks and Regards
Haamid

Hi John,

Thanks for the response, the blb table size is 70G where as the normal table size is 657M.
These are the settings which we have set before creating the index.
<sql novars "set delexp=0;"></sql>
<sql novars "set addexp='\alnum{1,30}';"></sql>
<sql novars "set addexp='\digit=[\digit\.,+]{1,30}';"></sql>
<sql novars "set addexp='>>[\xc0-\xfd]=[\x80-\xbf]+';"></sql>
<sql novars "set addexp='>>\alnum=[\alnum\x5c\x5f\x2d\x26\x23\x40\x2e\x25\x2c]{1,30}';"></sql>
<sql novars "set indexmeter=2;"></sql>
do we have to set anyother variable to fasten the process.

See also the other items John mentioned at http://www.thunderstone.com/site/texism ... rties.html

indexmem, indexspace, delindextmp, addindextmp