Page Counts

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Page Counts

Post 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?


User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Page Counts

Post by Thunderstone »



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




KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

Page Counts

Post 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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Page Counts

Post 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'"
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Page Counts

Post 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.
John Turnbull
Thunderstone Software
KMandalia
Posts: 301
Joined: Fri Jul 09, 2004 3:50 pm

Page Counts

Post 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.
Post Reply