If I perform a full text search on my catalog with no category
specified it takes less that a second to return a dataset of products
which match, however if I specify a category using either CategoryName
or CategoriesClause and set recursive to be true it takes upwards of 40
seconds. I appreciate that it will take longer but this is unusably so.
Obviously it speeds up the nearer I get to the leaves of the hierarchy.
I've tried creating a table with all the leaf Oids in and but joining
the results to this table but I can't get CommerceServer to allow me
to link on the ParentOid.
Can anyone recommend a method for speeding this up? Are there any
indexes I may be missing?
I am using code similar to that in the MSDN full text searching
examples.
Thanks,
Simon.
