Page Counts

Post by **Thunderstone** » Mon Mar 15, 1999 2:19 pm

Is there a way to get page counts for an index? One HTML table is
113 MB, can you estimate the number of pages indexed?

Post by **Thunderstone** » Mon Mar 15, 1999 3:53 pm

gw -st "select count(Url) from html"

KMandalia · Post by **KMandalia** » Mon Aug 23, 2004 4:28 pm

How can i display something like google that gives total number of pages indexed by the walker on the main search form?

Something like 'Now searching' (count)'pages'.

give me the exact sql statement if possible.

Post by **mark** » Mon Aug 23, 2004 5:48 pm

IIRC you have version 4 or 5, not 2. The SQL to get the count of records still pretty much the same as above, "select count(Url) Totalpages from html". But it would be more efficient to query the result of the walk stored in the options table in the default database, "select String Totalpages from options where Profile='YOURPROFILENAME' and Name='SSc_npages'"

Post by **John** » Tue Aug 24, 2004 9:47 am

Another way in the search script would be

<SQL "select npages from counts">
<fmt "Now searching %kd pages." $npages>
</SQL>

as the counts table maintains a count of pages in each profile.

KMandalia · Post by **KMandalia** » Tue Aug 24, 2004 9:48 am

My Mistake. I was able to do what I wanted after trying a couple of things. I should have tried a little more before posting.

Thanks.