Page 1 of 1

Page Counts

Posted: Mon Mar 15, 1999 2:19 pm
by Thunderstone



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?



Page Counts

Posted: Mon Mar 15, 1999 3:53 pm
by Thunderstone


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





Page Counts

Posted: Mon Aug 23, 2004 4:28 pm
by KMandalia
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.

Page Counts

Posted: Mon Aug 23, 2004 5:48 pm
by mark
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'"

Page Counts

Posted: Tue Aug 24, 2004 9:47 am
by John
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.

Page Counts

Posted: Tue Aug 24, 2004 9:48 am
by KMandalia
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.