- - - - - - - - - - - - - - - - - - - - - - - - - - - - Name: Maxime Subject: Re: show total sites
You may find the number of site indexed with this SQL-query to the search database; SELECT COUNT(*) FROM (SELECT distinct site_id FROM url) AS foo; Please note, this query works only for PgSQL and MySQL 5. The number and the size of documents indexed you can find with this SQL-query: SELECT COUNT(*), SUM(docsize) FROM url WHERE status IN (200,206,304,2200,2206,2304); Please note, these queries are very hard formedium and large databases, so it's better to run these queries periodically and write numbers into text file and then include this text file into your web-page. - - - - - - - - - - - - - - - - - - - - - - - - - - - - Read the full topic here: http://www.dataparksearch.org/cgi-bin/simpleforum.cgi?fid=02;topic_id=1218615278
