Index creation taking a long time

Post Reply
haamid.gazi
Posts: 13
Joined: Wed Jun 25, 2008 11:30 am

Index creation taking a long time

Post by 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
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Index creation taking a long time

Post by John »

The time to create the index usually depends on the size of the data in MB. The factors that will impact it are the speed of the drives with the data and index, using separate drives for data, index, and temporary files may help. Also make sure indexmem is not set to a point where the index creation process is swapping as that will slow it down as well.
John Turnbull
Thunderstone Software
haamid.gazi
Posts: 13
Joined: Wed Jun 25, 2008 11:30 am

Index creation taking a long time

Post by 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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Index creation taking a long time

Post by mark »

Post Reply