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