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