To get number of docs per site_id:
select site_id, count(*) from urlword group by site_id;
-----Original Message-----
From: FL [mailto:[EMAIL PROTECTED]]
Sent: Montag, 11. M�rz 2002 13:27
To: [EMAIL PROTECTED]
Subject: [aseek-users] how many doc per server
Hi!
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 ?
Thanks.
Francois
