RE: [aseek-users] how many doc per server

From: Gregory Kozlovsky (no email)
Date: Mon Mar 11 2002 - 08:26:34 EST

To get number of docs per site_id:

    select site_id, count(*) from urlword group by site_id;

-----Original Message-----
From: FL [mailto:]
Sent: Montag, 11. März 2002 13:27
Subject: [aseek-users] how many doc per server


I want to know how many docs are indexed for each server I have in my conf
file. This is to control wich ones are too big.
I plan to make a short php script to interract with the MySQL DB : looping
the conf file where the server list stands and then, for each 'Server'
command make something like :

select count(url) from url where url like 'http://serverroot.dlt%' ;

Can someone tells me exactly wich SELECT I must do ?



Hosted Email Solutions

Invaluement Anti-Spam DNSBLs

Powered By FreeBSD   Powered By FreeBSD