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
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 database is
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:
//
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 .