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

From: FL (no email)
Date: Mon Mar 11 2002 - 17:05:34 EST


Ok, thanks. I will try my script and post it after.

Francois

>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
>To:
>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
>








Hosted Email Solutions

Invaluement Anti-Spam DNSBLs



Powered By FreeBSD   Powered By FreeBSD