Index creation taking a long time

[haamid.gazi]

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

[haamid.gazi]

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.

[mark]

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

indexmem, indexspace, delindextmp, addindextmp