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
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:
//
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
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
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
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
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 (