UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Alexander Barkov
May I suggest? Probably it will be more useful to create a separate table with one column and one raw and store current documents number there: CREATE TABLE ndocs (ndocs int); Then after every reindexing run this: DELETE FROM ndocs; INSERT INTO ndocs SELECT count(*) FROM url WHERE . Y

UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Laurent LEVIER
Ok, I will change my query with the first one. After a test, yes it slows the display of the page. So I changed a bit my howto. I removed the init.inc changes and put into template.inc after the lang_url_translation treatment: //

UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Laurent LEVIER
Corrected. Thanks! At 12:41 15/02/2001 +0400, Alexander Barkov wrote: >This "SELECT count(*) FROM url" will mean the TOTAL number >of documents. Note that it is actually not the number of >searchable documents, because some of them may be not indexed yet >when database is being populated during

Re[2]: UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Sergey Kartashoff
Hi! Thursday, February 15, 2001, 2:37:58 PM, you wrote: AB> Note that PHP front-end does not have $ndoc yet. I hope AB> Sergey will add it too. Ok. This will appear in the upcoming 3.1.2.5 release. But note, that i plan to freeze development of current mnogosearch-php branch. Next branch

Re: UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Alexander Barkov
In sql.c I made #define NDOCS_QUERY "SELECT count(*) FROM url" so, one can change it to whatever he want, for example: #define NDOCS_QUERY "SELECT ndocs FROM sys" Then just properly fill the "sys" table. P.S. Note that PHP front-end does not have $ndoc yet. I hope Sergey will add it

Re: UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Alexander Barkov
Well, $ndocs variable has been added into 3.1.11 sources. Regards. Alexander Barkov wrote: > > This "SELECT count(*) FROM url" will mean the TOTAL number > of documents. Note that it is actually not the number of > searchable documents, because some of them may be not indexed yet > when databas

UdmSearch: Re: Creation of a new feature of Mnogo PHP Search facility.

2001-02-15 Thread Alexander Barkov
This "SELECT count(*) FROM url" will mean the TOTAL number of documents. Note that it is actually not the number of searchable documents, because some of them may be not indexed yet when database is being populated during first indexing. Probably "SELECT count(*) FROM url WHERE status IN (