I've done that. I saw your other post about that and I've done it a couple of times and re-build the index. I have a forum but it's very small. This is a site that doesn't have a lot of traffic as it's a local association site.

name rows Kb Activity
SearchItemWordPosition 263574 5576 17369547

 

Ok, I'm a little new at this so here's what I did.

select * from searchItemWordPosition
order by searchitemwordid, contentposition


From that, looking at the data, If I'm doing this corectly, there are a bunch that have duplicate data on them.

for example SearchItemWordID 22492 is listed about 6 thousand times.

Anything you need me to do, just let me now and I'll do it, but you may have to walk me thru it to find the data you need or I can give you access.

Here is what I have.
1st column is SearchitemWordPositon ID, then SearchItemWordID, then contentPosition

Select * from SearchitemWordPosition
where searchitemwordid = 22492
order by searchitemwordpositionid

Below is a sample of the results:


780 22492 1
782 22492 1
785 22492 1
787 22492 1
790 22492 1
792 22492 1
795 22492 1
798 22492 1
800 22492 1
802 22492 1
804 22492 1
806 22492 1
808 22492 1
810 22492 1
813 22492 1
816 22492 1
818 22492 1
821 22492 1
824 22492 1
827 22492 1
830 22492 1
832 22492 1
835 22492 1
837 22492 1
840 22492 1
842 22492 1
845 22492 1
848 22492 1
851 22492 1
854 22492 1
858 22492 1
861 22492 1
863 22492 1
865 22492 1
868 22492 1
870 22492 1
872 22492 1
874 22492 1
875 22492 1
877 22492 1
878 22492 1
882 22492 1
884 22492 1
885 22492 1
888 22492 1
891 22492 1
893 22492 1
894 22492 1
9396 22492 1
9399 22492 1
9401 22492 1
9404 22492 1