RE: Rtree index creation very slow

Check whether the index is built bottump-up or not. The bottom-up index build is much faster that the top-down. I believe most of the datablades that use rtree ( SpatialWare, Geodatic etc. ) support it. If the blade you are using ( or the opclass used for creating the index in question) doesn't support that, then you might want to consider implementing the required support functions to enable it. Please refer to the R-Tree user guide. The chapter 2 has a detailed section on bottom-up build. thanx Prasad >From: Jose Luis Matute <matute@dydes.com> >To: informix-list@iiug.org >Subject: Rtree index creation very slow Date: Wed, 13 Jul 2005 09:42:51 >+0200 > >Hi, > >I'm dealing with a rtree index that takes 75 hrs to get created. The table >has 22M rows, nearly 2Gb data. Creating primary/foreign keys is reasonabily >fast (1 - 1,5 hrs), but creating the rtree index is a nightmare and won't >fit in the 12 hr. window to stop the service (as the trials ina a >development machine shows - reasonabily similar boxes). I've observed that >the disk isn't saturated, nor does memory (buffer pool/DSS memory). It >doesn't parallel (only one CPU used, although PDQ parameters are set >'correctly'). > >Any hint will be appreciated! > >Thanks in advance. >-- >Jos' Luis Matute Mart'nez >sending to informix-list _________________________________________________________________ Take MSN Search Challenge http://server1.msn.co.in/sp05/searchgames/index.aspx Win prizes everyday! sending to informix-list