Re: Way of accessing data...

If you already have the infomation in the database, then definitely query it for the number. Why?

SELECT count(*) FROM user
[download]

This question is a perfect candidate for the ChatterBox, which i invite to please consider asking your question there first.

UPDATE: says kiat "the hosting company sets a limit on the number of queries by the hour". So why didn't you specify that in your original question? That's very very important stuff that you should have said up front. Now the answer changes, naturally, to #2.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on Re: Way of accessing data... Download Code

Replies are listed 'Best First'.
Re: Re: Way of accessing data... by kiat (Vicar) on Apr 12, 2004 at 14:10 UTC
Thanks jeffa :) I'm partly concerned because the hosting company sets a limit on the number of queries by the hour for the particular package I'm purchasing. Hence, I'm wondering whether that sort of statistics can be saved into a textfile...	[reply]
Re: Re: Re: Way of accessing data... by waswas-fng (Curate) on Apr 12, 2004 at 14:41 UTC
Or to get the best of both worlds, have a cron set up to query the database every x minutes and dump the count to a flat file, you don't get artificially high numbers (in the case that you delete inactive users), and you don't get hit with excess queries. -Waswas	[reply]