Stephan,
This can be done with a simple select. But from time to time this select will become
too long. I made the attached script to solve this.
It creates automagically a table ndocs where lies a single record: the number of
indexed documents.
Launch it regularly to update and use this table in your WWW pages. It will be much
faster.
Current script speed: 46s to update ndocs when database contains 469750 indexed URLs
on a PC with a Duron 800, 30 GB UDMA100 HD under RedHat 6.2 and 128 MB RAM.
At 03:58 17/03/2001 +0300, Stephan wrote:
>Author: Stephan
>Email: [EMAIL PROTECTED]
>Message:
>Hello!
>I have just a simple question:
>To show the number of URL records in my mysql database on my webpage I just need to
>show on screen how many rows are in my URL table?
>
>stephan
>
>Reply: <http://search.mnogo.ru/board/message.php?id=1719>
>
>___________________________________________
>If you want to unsubscribe send "unsubscribe general"
>to [EMAIL PROTECTED]
Laurent LEVIER
IT Systems & Networks, Unix System Engineer
Security Specialist
Argosnet Security Server : http://www.Argosnet.com
"Le Veilleur Technologique", "The Technology Watcher"
ndocs-update
